![]() ![]() 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 I have documented every Excel formula with its syntax and a good number of examples.ġ02 Most Useful Excel Formulas with Examples A. Provide Your Valid Email Id below to download the PDF & Excel Files 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. Insert Special Character Symbol list in ExcelĪnother way to insert a special character symbol list in excel by typing its character code while pressing the ALT key.If you want to be a power user of MS Excel, you must master the most useful Excel formulas of Excel. So after pressing the ALT key and Char, you have to check for the Font Style. ![]() Note: Weddings, Wingdings & Arial are the FONT style. If the code doesn’t show as you required please check the font is it the same as described below.While the Alt key is pressed, type the sequence of numbers which you required on the right side of the numeric keypad from the Alt code in the below table.Num Lock key must be pressed, to activate the numeric key section of the keyboard (you can find on the right top corner side).Special Character Letter, you need to use an Alt keyboard sequence: ![]() Special Characters - Alt Keyboard Sequences CHAR Release the Alt key, and the character will appear.While the Alt key is pressed, type the sequence of numbers (on the numeric keypad) from the Alt code in the below table.Num Lock key must be pressed, to activate the numeric key section of the keyboard (you can find on right top corner side).To activate the special character, you need to use an Alt keyboard sequence: ![]()
0 Comments
Leave a Reply. |