*Happy Boxing Day All!***“IF” Functions**are some of the most useful and easy to use tools in Excel. There are several flavors of

**IF**to choose from, and each of them can aid you in making sense of your data. Here are my

*4 Favorite Ifs:***1. COUNTIF: =COUNTIF(Range, Criteria)**

For the

*, you can specify a cell, a simple number such as*

**Criteria****10**, or use a

*or*

**greater-than***criteria such as “*

**less-than****>20**”. Be sure to use the

*if doing a great-than or less-than analysis. Alternatively, you can r*

**quotation marks***that contains your criteria number (*

**efer to a cell***needed with that approach).*

**No quotation marks****2. SUMIF: =SUMIF(Range, Criteria, SumRange)**

The

*is the same as in*

**Criteria****COUNTIF**, but you have the option of applying it to a “

**”. These are the**

*SumRange***to add if the cells in the Range match the criteria. If**

*actual cells**is omitted, the cells in*

**SumRange****Range**are evaluated by criteria and added accordingly.

**3. IF: =IF(Condition, Value If True, Value If False)**

This function is extremely valuable as a stand-alone or in conjunction with other “

**ne***sted*” functions. You can use cell references for the “

*” or the “*

**Value If True***”, or insert words (e.g. IF(A1>10, “Pass”, “Fail”). Just be sure to use quotation marks if inserting actual words.*

**Value If False****4. IFERROR: =IFERROR(Value, Value If Error)**

Introduced for the first time in Excel 2007, this combines the

**IF**and

**ISERROR**functions, and essentially gives you greater control with potential

**s. Rather than just accepting the sometimes cryptic and less-than-helpful default error messages that Excel dishes out, you can**

*Error Message***your error messages for more clarity.**

*Customize***, IF functions are another great set of tools for Excel arsenal.**

*No IFs about it*

**Happy Holidays, All!**