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.
Table of Contents
7 Most Useful Excel Formulas
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])
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])
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)
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])
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])
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], …)
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], …)
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.
Pingback: Microsoft Excel vs Google Sheets | The Basic Differences in 2020