Budgeting & Finance

Excelling with Microsoft Excel 6: ‘If’ function

Just in case, you missed out on my earlier posts, you can check them out here:

  1. Excelling with Microsoft Excel: Self-learning series 1 (Shortcuts and sparklines)
  2. Excelling with Microsoft Excel: Self-learning series 2 (Accessibility options)
  3. Excelling with Microsoft Excel 3: Excel 2010 (Shortcuts and tips)
  4. Excelling with Microsoft Excel 4: Excel 2010 (Vlookup and formatting)
  5. Excelling with Microsoft Excel 5: Excel 2010 (Sparklines and Tables)
  6. Excelling with Microsoft Excel: VLOOKUP Illustration

Excel tips published on this blog are based on new information I come across in my online self-learn Excel 2010 course with Alison.

Excel tip for today: Use of the ‘if’ function in Excel

  • This is used to specify if a condition is true or false.

if formula

*Remember to use quotation marks if you want text to appear in a cell as displayed above. “True” and “False” are in quotation marks to display the text when the condition indicated (A2=B2) is or is not met.

Personally, I use it mostly to sort out my trial balance (TB) in the preparation of month end reports, it saves time in ensuring that the TB is balanced before proceeding with any form of analysis. See below for a quick pictorial presentation of what can be achieved with this excel function.

if function

*Take note of the “if” formula which I have circled in blue above*.

  • Lastly it can be used to determine if an expense is within or over budget.


*Take note of the formula circled in red above.

Hope you picked up something new from this post and remember to share your views on this post. This will help improve future posts on my self-learning journey.

Don’t forget to share your excel tips and tricks with us (E-mail omtsdigest@gmail.com and your tip might just be featured on this site!).