Excel functions along with their syntax:

by
  1. SUM: Adds up all the numbers in a range.
  • Syntax: =SUM(number1, [number2], ...)
  1. AVERAGE: Calculates the average of a range of numbers.
  • Syntax: =AVERAGE(number1, [number2], ...)
  1. COUNT: Counts the number of cells that contain numbers.
  • Syntax: =COUNT(value1, [value2], ...)
  1. IF: Performs a conditional test and returns values based on the result.
  • Syntax: =IF(logical_test, [value_if_true], [value_if_false])
  1. VLOOKUP: Searches for a value in the first column of a table and returns a value in the same row from another column.
  • Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
  1. HLOOKUP: Searches for a value in the first row of a table and returns a value in the same column from another row.
  • Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
  1. INDEX: Returns the value of a cell in a specified row and column of a range.
  • Syntax: =INDEX(array, row_num, [column_num])
  1. MATCH: Searches for a specified value in a range and returns the relative position of that item.
  • Syntax: =MATCH(lookup_value, lookup_array, [match_type])
  1. CONCATENATE (or CONCAT): Combines two or more text strings into one string.
  • Syntax: =CONCATENATE(text1, [text2], ...)
  1. LEFT: Returns a specified number of characters from the beginning of a text string.
    • Syntax: =LEFT(text, num_chars)
  2. RIGHT: Returns a specified number of characters from the end of a text string.
    • Syntax: =RIGHT(text, num_chars)
  3. IFERROR: Returns a value you specify if a formula results in an error; otherwise, it returns the result of the formula.
    • Syntax: =IFERROR(value, value_if_error)

These are just a few examples, and Excel offers a wide range of functions to perform various calculations and operations. The syntax may vary slightly depending on the specific function and its parameters.

Leave a Comment