Skip to main content
Board of Directors
NEW! Sponsor an e-Learning Webinar
Key 2018 Annual Statement Changes (12-10-18)
2018 NAIC Summer Meeting Review
Excel Workshop - What is Your Challenge (Archived 8-7-2018)
US Tax Reform - Changes Today and Beyond (Archived 7-10-18)
Technology Innovation Award Winner Webinar (Archived 6-21-18)
2018 NAIC Spring Meeting Review (Archived 5-2-2018)
Economic Outlook 2018 (Archived 4-25-2018)
P&C Financial Accounting - Solution Provider Overview (Archived 4-3-2018)
Leveraging Blockchain Technologies to be Transformed (Archived 3-22-2018)
PowerPoint: Building Your Presentation from Scratch (Archived 2-15-2018)
How to Give Feedback (Archived 2/22/2018)
2017 NAIC Fall Meeting Review (Archived 1-10-18)
Key 2017 Annual Statement Changes_GAAP Update (Archived 12-18-17)
Economic Outlook 2018 (Archived 12-7-17)
Refreshing the NYDFS: Cyber Security Best Practices (Archived 11-16-17)
2017 NAIC Summer Meeting Review (Archived 10-12-17)
Excel Tips and Tricks: Dashboards (Archived 9-27-2017)
Expense Management and Budgeting (Archived 9-6-2017)
How to Act Like an Entrepreneur...(Archived 7-20-2017)
e-learning Internal Training Archive
In-Person Education Programs
Executive Education Program
Local Chapter Events
Solution Provider Program
Statutory Accounting Training
On-Line Education Programs
Other Education Resources
Continuing Education Credit
Skip breadcrumb navigation
Excel Tip of the Month - May 2017: IF Function
By Aaron Cooper, Partner, Brown Smith Wallace
Highly flexible, yet simplistic is the best way to describe the Microsoft Excel IF function. The IF function is used to test for or evaluate a condition, and then return one value if the condition is TRUE, or another value if the condition is FALSE.
The IF function is a built-in Logical Function in Excel. As a worksheet function, the IF function can be entered as part of a formula in a cell of a worksheet.
The IF function has 3 arguments, but only the first one is mandatory, the other two are optional.
logical_test - a value or logical expression that is either TRUE or FALSE. In this argument, you can specify a text value, date, number, or any comparison operator. For example, your logical test can be expressed as B1="sold", B1<12/1/2014, B1=10 or B1>10.
value_if_true - the value Excel will put in a cell if the test evaluates to TRUE. For example, the following formula will return the text "Good" if a value in cell B1 is greater than 10: =IF(B1>10, "Good").
value_if_false - the value Excel will put in a cell if the test evaluates to FALSE. For example, if you add "Bad" as the third parameter to the above formula, it will return the text "Good" if a value in cell B1 is greater than 10, otherwise, it will return "Bad": =IF(B1>10, "Good", "Bad").
The next time you need to test a condition in Excel, remember to utilize the IF function since it provides endless possibilities due to its flexibility and simplicity.
Aaron is a partner in the Brown Smith Wallace Insurance Advisory Services practice. He is a regular content contributor to IASA national and the St. Louis chapter. You can reach Aaron at firstname.lastname@example.org.
Return to May eInterpreter