5 Most Used Excel Formulas - if, Sumif, Countif, Vlookup, Match

                            5 Most Used Excel Formulas - if, Sumif, Countif, Vlookup, Match

5 Most Used Excel Formulas - Friends, there are a lot of Formulas in Excel, but learn which and which is not, but in this post, we have told about 5 Most Used Excel Formulas of Excel that you must come to know. 5 Most Used Excel Formulas - if, Sumif, Countif, Vlookup, Match

1) - if formula excel - how to use IF function in Excel
In Excel, the formula is given to get different results for many different conditions. Let's know how to apply this formula -
The syntax of the IF function is as follows: -
IF (logical_test, [value_if_true], [value_if_false])

2) - Sumif formula excel - How to use Sumif function in Excel
If there is such a list in your axle file, there is an item that is written more than once and you have to equal the number written in front of it, then this formula is required like if you make a bill and there is one item in it If it is more than once, write it in front of it, you can calculate the amount in one go. The syntax of Sumif function is as follows: -
SUMIF (range, criteria, [sum_range])

3) - Countif formula excel - How to use Countif function in Excel
In Excel, the Countif formula is used to account any number or any name that appears more than once in any list.
The syntax of the countif function is as follows: - COUNTIF (range, criteria)

4) - Vlookup formula excel - How to use Vlookup function in Excel
We will find it on lookup, 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 - how to use Vlookup function in Excel
The match function is used to denote the position of any name or value given in the table, although this formula is very small but combined with other formulas it becomes a very powerful formula.
The syntax of MATCH function is as follows: - MATCH (lookup_value, lookup_array, [match_type])