Master Excel with our comprehensive formula reference. Syntax, examples, and real-world use cases.
20
Formulas
8
Categories
100+
Examples
Showing all 20 formulas
Adds all numbers in a range of cells. The SUM function is one of the most commonly used functions in Excel.
=SUM(number1, [number2], ...)Returns one value if a condition is TRUE and another value if it's FALSE. Essential for conditional logic in Excel.
=IF(logical_test, value_if_true, value_if_false)Searches for a value in the first column of a table and returns a value in the same row from another column. Vertical lookup.
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])Counts the number of cells that contain numbers in a range. Ignores text, logical values, and empty cells.
=COUNT(value1, [value2], ...)Calculates the arithmetic mean of numbers in a range. Ignores text and logical values.
=AVERAGE(number1, [number2], ...)Adds cells that meet a specific condition or criteria. Perfect for conditional sum calculations.
=SUMIF(range, criteria, [sum_range])Counts cells that meet a specific condition. Essential for conditional counting and data analysis.
=COUNTIF(range, criteria)Returns the largest value in a set of numbers. Ignores text and logical values.
=MAX(number1, [number2], ...)Returns the smallest value in a set of numbers. Ignores text and logical values.
=MIN(number1, [number2], ...)Returns the number of characters in a text string, including spaces and special characters.
=LEN(text)Joins two or more text strings into one string. Note: CONCAT and & operator are modern alternatives.
=CONCATENATE(text1, [text2], ...)Extracts a specified number of characters from the start of a text string.
=LEFT(text, [num_chars])Extracts a specified number of characters from the end of a text string.
=RIGHT(text, [num_chars])Returns the current date as a serial number. Updates automatically when the worksheet is recalculated.
=TODAY()Returns the current date and time as a serial number. Updates automatically on recalculation.
=NOW()Rounds a number to a specified number of digits. Essential for financial calculations and display formatting.
=ROUND(number, num_digits)Returns the absolute value of a number (removes negative sign). Always returns a positive number or zero.
=ABS(number)Returns TRUE if all arguments are TRUE. Used to test multiple conditions simultaneously.
=AND(logical1, [logical2], ...)Returns TRUE if any argument is TRUE. Used to test if at least one condition is met.
=OR(logical1, [logical2], ...)Reverses the logic of its argument. Returns TRUE if argument is FALSE, and FALSE if argument is TRUE.
=NOT(logical)Use our AI-powered formula generator to create custom formulas instantly
Generate Custom Formula