10 Most Popular functions

1- SUM [SUM, SUMIF, SUMIFS, SUMPRODUCT]

Use this function to add the values in cells.

2- COUNT [COUNT, COUNTIF, COUNTIFS, COUNTA, COUNBLANK]

Use this function to count the cells.

3- IF [IF, IFS, IFNA, IFERROR]

Use this function to return one value if a condition is true and another value if it's false.

4- LOOKUP [LOOKUP, VLOOKUP, HLOOKUP]

Use this function when you need to look in a single row or column and find a value from the same position in a second row or column.

5- MATCH

Use this function to search for an item in a range of cells, and then return the relative position of that item in the range.

6- CHOOSE

Use this function to select one of up to 254 values based on the index number.

7- DATE

Use this function to return the sequential serial number that represents a particular date. This function is most useful in situations where the year, month, and day are supplied by formulas or cell references.

8- FIND [FIND, SHEARCH]

Use this function to find the value in the string in the cell. They return the number of the starting position of the first text string from the first character of the second text string.

9- INDEX

Use this function to return a value or the reference to a value from within a table or range.

10- AND [AND, OR]

Use this function to do the multi-logical tests as TRUE / FASLE result.