Excel Functions

Discover all Excel functions with detailed explanations, syntax, and interactive examples. Master spreadsheet formulas one function at a time.

ABS

Function

Returns the absolute value of a number

=ABS(number)
Learn more → Interactive

SUM

Function

Adds all the numbers in a range of cells

=SUM(number1, [number2], ...)
Learn more → Interactive

VLOOKUP

Function

Searches for a value in the first column of a range and returns a value in the same row from another column

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Learn more → Interactive