Asking "What If" in Excel

What IF? We often ask this question! You can also ask it in an Excel formula using the IF function. A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions including sum, average and count.

The IF function tests whether a condition is true or false and then performs an action. An example is shown in the screen shot below. If the value in L2 (the Total value) is greater than 500, then enter High in M2; if not, enter Low in M2, written as =if(L2>500,”High”,”Low”). Note - always enclose text in double quotation marks.

Contact me at sharon_daniel@att.net for support on using the IF function. Need help with Excel - coaching, data analysis and/or training? Contact me at 561-289-9484 to discuss your needs. See my website for a complete list of the ways I can help you - InfoExpressVBC.com.