Skip to main content

Membership is free!

Common Excel functions, categorized by their primary usage:

Mathematical and Trigonometric Functions

  1. SUM: Adds all the numbers in a range of cells.
  2. AVERAGE: Returns the average (arithmetic mean) of the numbers provided.
  3. SUMIF: Adds the cells specified by a given condition or criteria.
  4. SUMIFS: Adds the cells specified by a given set of conditions or criteria.
  5. AVERAGEIF: Returns the average (arithmetic mean) of the cells specified by a given condition or criteria.
  6. AVERAGEIFS: Returns the average (arithmetic mean) of the cells specified by a given set of conditions or criteria.
  7. COUNT: Counts the number of cells that contain numbers.
  8. COUNTA: Counts the number of cells that are not empty.
  9. COUNTIF: Counts the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.
  10. COUNTIFS: Counts the number of cells that meet multiple criteria.
  11. MIN: Returns the smallest number in a set of values.
  12. MAX: Returns the largest number in a set of values.
  13. MINIFS: Returns the smallest number in a set of values, based on one or more criteria.
  14. MAXIFS: Returns the largest number in a set of values, based on one or more criteria.
  15. PRODUCT: Multiplies all the numbers given as arguments and returns the product.
  16. SQRT: Returns the square root of a number.
  17. POWER: Returns the result of a number raised to a power.
  18. MOD: Returns the remainder after a number is divided by a divisor.
  19. ROUND: Rounds a number to a specified number of digits.
  20. ROUNDUP: Rounds a number up, away from zero.
  21. ROUNDDOWN: Rounds a number down, towards zero.
  22. TRUNC: Truncates a number to an integer by removing the fractional part of the number.
  23. CEILING: Rounds a number up to the nearest integer or to the nearest multiple of significance.
  24. FLOOR: Rounds a number down to the nearest integer or to the nearest multiple of significance.
  25. ABS: Returns the absolute value of a number.

Statistical Functions

  1. MEDIAN: Returns the median of the given numbers.
  2. MODE: Returns the most frequently occurring value in a set of data.
  3. STDEV: Estimates standard deviation based on a sample.
  4. STDEVP: Calculates standard deviation based on the entire population.
  5. VAR: Estimates variance based on a sample.
  6. VARP: Calculates variance based on the entire population.

Logical Functions

  1. IF: Returns one value if a condition is true and another value if it's false.
  2. AND: Returns TRUE if all its arguments are TRUE.
  3. OR: Returns TRUE if any argument is TRUE.
  4. NOT: Reverses the logic of its argument.
  5. IFERROR: Returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.

Lookup and Reference Functions

  1. VLOOKUP: Looks for a value in the leftmost column of a table and returns a value in the same row from a column you specify.
  2. HLOOKUP: Looks for a value in the top row of a table or array and returns a value in the same column from a row you specify.
  3. INDEX: Returns the value of an element in a table or array, selected by the row and column number indexes.
  4. MATCH: Searches for a specified item in a range of cells and then returns the relative position of that item in the range.
  5. OFFSET: Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.
  6. CHOOSE: Chooses a value or action to perform from a list of values, based on an index number.
  7. INDIRECT: Returns the reference specified by a text string.
  8. TRANSPOSE: Returns a vertical range of cells as a horizontal range, or vice versa.

Text Functions

  1. CONCATENATE: Joins several text strings into one text string.
  2. TEXT: Formats a number and converts it to text.
  3. LEFT: Returns the first character or characters in a text string, based on the number of characters you specify.
  4. RIGHT: Returns the last character or characters in a text string, based on the number of characters you specify.
  5. MID: Returns a specific number of characters from a text string, starting at the position you specify.
  6. LEN: Returns the number of characters in a text string.
  7. FIND: Finds one text value within another (case-sensitive).
  8. SEARCH: Finds one text value within another (not case-sensitive).
  9. UPPER: Converts text to uppercase.
  10. LOWER: Converts text to lowercase.
  11. PROPER: Capitalizes the first letter in each word of a text value.

 

This list covers many of the commonly used Excel functions. Depending on your specific needs, there are many other specialized functions available in Excel as well.

Cron Job Starts