Microsoft Excel formulas menu

This little gem finds its way into Matric finals over and over again. It takes some practice to get your head around the logic, so let’s begin!

Your standard IF statement has 3 parts and goes something like:

  1. if something is true,
  2. do this,
  3. otherwise do that.

Let us say it is sports day at school and we need to award gold, silver and bronze medals to the first three athletes in an event. Following the above logic for the IF statement:

  1. If the athlete placed first
  2. award them the gold medal
  3. otherwise, award them the silver medal

Oh dear: that won’t work – no bronze medal! Let’s try again:

  1. If the athlete is in first place
  2. award them the gold medal
  3. if the athlete placed second
  4. award them the silver medal
  5. otherwise, award them a bronze medal.

Here we have an IF statement that has an IF statement “inside” of it as the FALSE part of the first, main IF statement. Now we need Excel to perform this logic…

The formula in cell C2 (which can then be copied downwards) is:

=IF(B2=1,"GOLD",IF(B2=2,"SILVER","BRONZE"))

By MisterFoxOnline

CAT Educator

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.