0 of 135 lessons complete (0%)
Function and Formula Basics

If THIS then THAT Examples

This is a preview lesson
Purchase this course, or sign in if you’re already enrolled, to take this lesson.

IF this then that Examples

IF Ex 1

To follow along go to 24.2.1

In this example, you want to differentiate between employees ratings that are above 5 and below 5. In D11 to D30 create an IF function that says above average if the rating is bigger than 5 and below average if less than 5.

Solution

IF Ex 2

To follow along go to 24.3.1

In this example you want to differentiate between employees ratings that are above average and below average.

  • In C31, create an average formula for the ratings above.
  • In D11 to D30 create an IF function that basis the above average or below average on the answer in cell C31.

Solution

IF Ex 3

To follow along go to 24.4.1

You are given a trial balance which shows the Debits and Credits in different columns. You want to create a third column (yellow cells) where you will show a debit as a positive number, and a credit as a negative number.

In the yellow cells, create an IF function that will check if the debit for the relevant row is 0, in which case it must pull through the NEGATIVE of the credit column, otherwise bring through whatever is in the debit column. A visual representation of the decision is shown below

If_Ex_3_decision_tree

Solution