The IF Statement Our Best Computer Cheat Sheets Previous Article Best Presentation Software Next Article Excel tutorial IF is one of the functions in the Logical function set of the Formulas tab in Excel. Its greatest use is for running a test and providing a response based on a true or false result. IF is quite a flexible statement and can be used in combination with many others, such as AND, OR, and SUMIF. In this example it is used to provide two results. A text result, and then again, in another row to return a calculated number. Here, row 2 contains monthly sales figures, we can use the IF to see if they are on target. In Cell B4, where we want our answer to appear, we run a test to see if the sales meet the target amount. Test: Is B2 greater than or equal to 3500? If the test is true, then we can have the word “Hit” appear. If the test returns as false, then we have the word “miss” appear. (All text responses in this function must be in inverted comas). The function writes as =IF(B2>=3500,”Hit”,”miss”) In row 6, we can use the IF to perform a calculation. We run a test to see if the sales meet the target amount. If the answer is true, then we multiply the sales by the commission for a result. If it’s false, we get zero. The function writes as =IF(B2>=3500,B2*2%,0) These are just two uses of IF. It can be adapted even more powerfully when combined with others. You may be interested in our Excel training courses: Excel 2013 - Part 1 Excel 2013 - Part 2 Excel 2013 - Part 2 Excel 2013 - Part 3 Excel 2013 - Part 3 Excel 2013 Formulas & Charts Excel 2013 Programming with VBA Excel 2013 Tables, PivotTables and Conditional Formatting Excel 2013: Data Analysis with Pivot Tables Sign up For Advanced Office Cheat Sheet Pack & Office Webinars Webinar Recordings: Tips & Tricks for Using Office 365 Microsoft Excel 2016: Creating PivotTables Getting Started with Microsoft Excel 2016 Getting Started with Microsoft Word 2016 Latest Cheat sheets: Newly updated Excel cheat sheet Updated Word cheat sheet Updated Outlook cheat sheet Popular Office shortcuts cheat sheet Windows 10 cheat sheet Web browser cheat sheet Adobe Acrobat cheat sheet More published as they become available Get access now! Monday, January 4, 2016 / Author: Liam Phelan / Number of views: 3517 / Comments: 0 / Print Categories:Microsoft OfficeTech Tips Tags:Office Excel Related articles Data Visualisation with Excel & Power BI Printing from Excel - 3 useful things to know How to Import Data from PDF into Excel Excel Tips and Tricks from our Experts The Differences Between Office 2019 and Office 365