7 Most Useful Excel Formulas – If, Sumif, Countif, Vlookup, Match, Subtotal, And Concatenate.

7 Most Used Excel Formulas – Guys, there are lots of Formulas in Excel, but which we learn and which is not, but in this post, we have told about 7 Most Used Excel Formulas of Excel that you must to know. 7 Most Used Excel Formulas Are IF, SUMIF, COUNTIF, VLOOKUP, MATCH, SUBTOTAL, AND CONCATENATE.

IF FORMULA IN EXCEL:-

The IF function can perform a logical test and return one value for a TRUE result, and another for a FALSE result. the formula is given to get different results for many different conditions. Let’s know how to For example, to “pass” scores above 30: =IF(C5>=30,”Pass”,”Fail”). More than one condition can be tested by nesting IF functions. The IF function can be combined with logical functions like AND and OR.

Syntax: – =IF (logical_test, [value_if_true], [value_if_false])

IF FORMULA IN EXCEL-IMG

SUMIF FORMULA IN EXCEL:-

The Excel SUMIF function returns the sum of cells that meet a single condition. Criteria can be applied to dates, numbers, and text. The SUMIF function supports logical operators (>,<,<>,=).

 Syntax: – =SUMIF (range, criteria, [sum_range])

SUMIF FORMULA EXCEL-IMG

COUNTIF FORMULA IN EXCEL: -

COUNTIF is a function to count cells that meet a single criterion. COUNTIF can be used to count cells with dates, numbers, and text that meet specific criteria. The COUNTIF function supports logical operators (>,<,<>,=).

 Syntax: – =COUNTIF (range, criteria)

3)COUNTIF FORMULA EXCEL-IMG

VLOOKUP FORMULA IN EXCEL: -

VLOOKUP is an Excel function to look up and get data from a specific column in table. VLOOKUP supports approximate and exact matching, The “V” stands for “vertical”. Lookup values must appear in the first column of the table, with lookup columns to the right.

 Syntax: – =VLOOKUP (value, table, col_index, [range_lookup])

VLOOKUP FORMULA EXCEL-IMG

MATCH FORMULA IN EXCEL: -

MATCH is an Excel function used to locate the position of a lookup value in a row, column, or table. MATCH supports approximate and exact matching. Often, the INDEX function is combined with MATCH to retrieve the value at the position returned by MATCH.

 Syntax: – =MATCH (lookup_value, lookup_array, [match_type])

MATCH FORMULA EXCEL-IMG

SUBTOTAL FORMULA IN EXCEL: -

The Excel SUBTOTAL function returns an aggregate result for supplied values. SUBTOTAL can return a SUM, AVERAGE, COUNT, MAX, and others and SUBTOTAL function can either include or exclude values in hidden rows.

 Syntax: – =SUBTOTAL (function_num, ref1, [ref2], …)

SUBTOTAL FORMULA EXCEL-IMG

CONCATENATE FORMULA EXCEL: -

The Excel CONCATENATE function concatenates (joins) join up to 30 text items together and returns the result as text. The CONCAT function replaces CONCATENATE in newer versions of Excel. The ampersand character (&) is an alternative to CONCATENATE. The result is the same, but the ampersand is more flexible.

 Syntax: – =CONCATENATE (text1, text2, [text3], …)

CONCATENATE FORMULA EXCEL-IMG

You Can Download Excel Practice Workbook By Click Download

if you guys like this types of post then comment below , which topic we should post in next . keep touch with us cause we always bring this type of topics related post found in our website, thanks for reading & gaining Knowledge.

This Post Has One Comment

Leave a Reply