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

INDRAJIT
0

 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, although there are many Formulas in Excel, but which one should be learned and which one is not, but in this post we have told 5 Most Used Formulas of Excel which you must come, let us know 5 Most Used Excel Formulas - If, Sumif, Countif, Vlookup, Match


if formula excel - how to use IF function in Excel

The formula in Excel is given to obtain different results for various conditions. Let's learn how to apply this formula.


The syntax of IF function is as follows:-

IF(logical_test, [value_if_true], [value_if_false])


Sumif formula Excel - How to use Sumif function in Excel

If you have a list in your Excel file with an item that is written more than once and you need to add up the number written next to it, then you need to use this formula. For example, if you create a bill and there is one item that is written more than once, this formula can calculate the total amount written next to it in one go.


The syntax of Sumif function is as follows:-

SUMIF(range, criteria, [sum_range])


Countif formula Excel - How to use Countif function in Excel

The Countif formula is used in Excel to count the number of times a particular number or name appears in a list where there are multiple occurrences


The syntax of countif function is as follows:-

COUNTIF(range, criteria)


Vlookup formula Excel - How to use Vlookup function in Excel


VLOOKUP WILL BE USED IN EXCEL WHEN YOU HAVE TO SEARCH VERTICALLY FOR A SPECIFIC VALUE OR LOOKUP VALUE


The syntax of Vlookup function is as follows:-

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])


Match formula Excel - How to use Match function in Excel

The MATCH function is used to show the position of any given name or value in a table. Although this formula is very small, it becomes a very powerful formula when combined with other formulas.


The syntax of MATCH function is as follows:-

MATCH(lookup_value, lookup_array, [match_type])





Tag-5 Most Used Excel Formulas, Most Used Excel Formulas, Excel, countif, sumif, sumif in hindi, countif Formula, excel formulas, Excel Formulas, Sumif Formula, excel user, if Formula, match Formula, excel tutoria,excel sumif, ms office user, vlookup, match, Microsoft excel (software), excel tips, microsoft excel






Post a Comment

0Comments
Post a Comment (0)