|=SUM(Cell Refernce, Cell Refernce)||It allows you to add two 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.
|=LEN(Cell Refernce)||The LEN formula counts the number of characters in a cell. Be careful though! This includes spaces.|
|=TRIM(Cell Refernce)||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.