|=SUM(Cell Refernce, Cell Refernce)
|It allows you to add 2 or more numbers together. You can use cell references as well in this formula.
|=COUNT(Cell Refernce:cell Refernce)
| The count formula counts the number of cells in a range that have numbers in them.
This formula only works with numbers.
|=COUNTA(Cell Refernce:Cell Refernce)
| Counts the number of non-empty cells in a range. It will count cells that have numbers
and/or any other characters in them. The COUNTA Formula works with all data types.
|The LEN formula counts the number of characters in a cell. Be careful though! This includes spaces.
|Gets rid of any space in a cell, except for single spaces between words.
|=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
|Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify�
|=IF(logical_statement, return this if logical statement is true, return this if logical statement is false)
|Gives the desired intelligence to a program, so that it can take decisions based on a criteria and most importantly decide the program flow.
|=SUMIF(range, criteria, sum_range)
|It allows you to add 2 or more numbers together, if condition is satisfied.
Do you have any Query On Level-2 Content.
Leave your details here, our customer care executive will call you in a short while.