5 Most Used Excel Formulas - If, Sumif, Countif, Vlookup,

5 Most Used Excel Formulas - If, Sumif, Countif, Vlookup,

1) if the formula excel - 

The syntax of the IF function is as follows:-
IF(logical_test, [value_if_true], [value_if_false])

2) Sumif formula excel - 

If there is such a list in your excel file, there is an item which is written more than once and you have to sum the number written in front of it, then this formula is needed like if you make a bill and anyone item in it If there is more than once then it can calculate the amount written in front of it in one go

The syntax of sumif  function is as follows:- 
SUMIF (range, criteria, [sum_range])

3) Countif formula excel -  

The countif formula is used to account for any number or any name occurring more than once in any list in Excel. 

The syntax of countif function is as follows:- 
COUNTIF (range, criteria)

4) Vlookup formula excel -  

Found on V Lookup is used in Excel when you have to search vertically for a particular value or lookup value.

The syntax of the Vlookup function is as follows:-
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

5) Vlookup formula excel - 

The match function is used to define the position of any given name or value in the table, although this formula is very short, when mixed with other formulas, it becomes a very strong formula.

The syntax of MATCH function is as follows:-
MATCH(lookup_value, lookup_array, [match_type])