IF Statements are what is called a LOGICAL test, such as is this value larger than this, if true do (or display) this, if false then do (or display) that. IF statements can be used for a lot of different things and all of them save you having to manual go through the data and perform the calculations themselves.

These are some examples of how IF statement can be used:

= IF (Question eg B17>B16, do this, otherwise do this)

OR, if you want to show text

=IF(Question eg B17>B16, “Text if correct”, “Text if incorrect”)

OR if you want to perform a calculation

=IF(Question eg B17>B16, if yes multiply sales by 2%, if not multiply sales by 1.5%)

We’ve attached the file that we used to create the image in this blog post so you can open the file and see the formulas that we have entered into cells D7 and E7. Click on each cell to see the formula. See if you can duplicate these values down each column.

Excel exercise file: Sales Commission IF – Intro

If you’d like to participate in our online Microsoft Excel training course visit this link.

Want to do a course online but not sure how online training courses work?

If you want to have a group of people training in your office or our training centre call us on (02) 9971 0000 or visit our online schedule to enrol into Class-Based Training in Chatswood, Sydney.

Steve Slisar

Steve Slisar has been training people how to use computers since 1994, opened a training centre in 1999 in Dee Why and by 2005 had 3 training centres and created over 35 individual courses that include Screen videos with audio commentary, training workbooks for those who prefer to read to learn, and exercise files that are used with the tasks in the workbooks so you get practical experience in the software you are trying to learn. Now the creator of 5 of the most popular online MYOB training courses in Australia.

Recent Posts

How does $20,000 mortgage repayments equate to $47,598.02?

All eyes will be on the announcement from the Reserve Bank Governor today to see…

1 day ago

Cyber Security for Bookkeepers – How are scammers trying to get you

Every contract bookkeeper loves receiving these emails but they can wreak havoc with your computer…

2 weeks ago

Engaging a New Worker? Here Are The Things You Need To Do, particularly if you’re classified by the ATO as a withholder:

There’s lots to do when businesses engage a new worker.  As an employer, you’ll be…

4 weeks ago

Cert IV in Bookkeeping and Accounting + MYOB and Xero Course TRIO

Not every students needs a Cert IV in Bookkeeping and most business admin and accounts…

4 weeks ago

COMPLETE Xero Course includes Beginners to Advanced skills

This Xero course is the most popular with job seekers and business owners because it…

1 month ago

Career Academy updates for 2025

Feel like you need a little something extra? Have you reviewed your life in 2024…

1 month ago