Share Nairobi Business Courses Posts

How to use the IF Function

This is one of the most popular functions in spreadsheets because it compares values and returns a decision based on the comparison.

The IF function allows you to make logical comparisons between two different values.

IF statements can have two results. The first result is if your comparison is True, the second if your comparison is False.

This is useful in a real situation where for instance you are comparing budgeted amounts with actual expenditures.

Lets say for instance you run a small office in Nairobi. You have given your manager a budget for monthly expenditures on consumables such as printer ink, stationery and tea.

At the end of the month he brings your the actual amounts spent and you want to know quickly if he has been within or exceeded budgets and for which items.

For example, =IF(Budget > Actual,”Good”,”Bad”) means IF(Budget is greater than Actual spend, then return “Good”, otherwise return “Bad”).

This is just one simple example of where using the IF function would be of use to you.

Click here now to read more about our Excel Spreadsheet courses

Nairobi Business Courses is a one on one trainer for professional and personal business skills in Nairobi, Kenya.

You can keep in touch with us on twitter Click to follow us on Twitter here Facebook Page Click to follow us on Facebook here

Our sister business Digital Marketers offers digital marketing consultancy services visit them at Digital Marketers Nairobi

Play IF Function explainer video

Share Nairobi Business Courses Posts