Want to get free access to our Excel functions course?

Fill in your e-mail address and telephone and we will give you 7 days free access to our course The Excel Functions Guide.

We will now be going through the If function, which checks whether or not a condition is met, and returns a different value depending on whether the condition is TRUE or FALSE.

The IF function consist of 3 arguments, the condition, the return value if the condition is True, and the value if it is False.

For example, we can check if the number in cell B8 is greater or less than 50. We’ll type IF, B8 is greater than 50. We’ll have the letter T, as in True, if the condition is TRUE, and the letter F, as in False if it’s FALSE. The result is that the value in B8 is less than 50.

We can copy the formula downward to also see if the value in cell B9 is greater than 50, which we see is true.
In this lesson we have gone through the ever-useful IF-function.