Returns the average (arithmetic means) of its arguments, which can be numbers or names, arrays, or references that contain numbers Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression Returns value_if_error if the expression is an error and the value of the expression itself otherwise =IF(logical_test,, Ĭhecks whether a condition is met, and returns one value if TRUE, and another value is FALSE =COUNTIFS(criteria_range1, criteria1,, …)Ĭounts the number of cells specified by a given set of conditions or criteria =SUMIFS(sum_range, criteria_range1, criteria1,, …)Īdds the cells specified by a given set of conditions or criteria
=AVERAGEIFS(average_range, criteria_range1, criteria1,, …)įinds average (arithmetic mean) for the cells specified by a given set of conditions or criteria
=AVERAGEIF(range, criteria, )įinds average (arithmetic mean) for the cells specified by a given condition or criteriaĪdds the cells specified by a given condition or criteriaĬounts the number of cells within a range that meet the given condition If a cell is not blank, it returns FALSE.Ĭhecks whether a value is an error (#VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!) excluding #N/A, and returns TRUE or FALSEĬhecks whether a value is an error (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), and returns TRUE or FALSEĬhecks whether a reference is to a cell containing a formula, and returns TRUE or FALSEĬhecks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSEĬhecks whether a value is #N/A, and returns TRUE or FALSEĬhecks whether a value is a number, and returns TRUE or FALSEĬhecks whether a value is a reference, and returns TRUE or FALSEĬhecks whether a value is text, and returns TRUE or FALSEĬhecks whether a value is not text (blank cells are not text), and returns TRUE or FALSE xlsx file 102 Most Useful Excel Formulas with Examples A.
#EXCEL 2016 VBA AND MACROS PDF FREE DOWNLOAD DOWNLOAD#
I have documented all the above Excel formulas in a single Excel sheet so that you can tweak the formulas to understand and practice better.Ĭlick here to download the. I have documented every Excel formula with its syntax and a good number of examples.Ĭlick here to download the PDF Excel Formulas with Examples in an Excel Sheet (Free Download. uses.įurther Readings Download Excel Formulas Cheat Sheet PDFĬlick on the button below to download the PDF with 102 Excel Functions. N.: I did not include here the specialized formulas for Engineering, Statistical, Web, etc. You cannot use this PDF for any kind of commercial use.ī. You can download the PDF and print it to use it anywhere, but for personal use. In this Excel Formulas Tutorial, I am sharing here the most useful 102+ Excel formulas cheat sheet and downloadable free PDF. You can use this trick to master anything complex, not only Excel formulas. This helps me a lot while I am trying to solve an Excel problem with formulas. Then wherever I see the name of an Excel formula, I can quickly remember its syntax and uses. This revision makes a permanent image of the formulas in my brain.
Let me share the trick that I used and still use to master the formulas: I used to revise 5-10 Excel formulas every day before start working anything with Excel. To be frank, it is not an easy task for all as the functions are a lot in numbers. If you want to be a power user of MS Excel, you must master the most useful Excel formulas of Excel.