IF Functions Excel

IF Functions Excel

Grade 9 Computer

​IF Function

The IF function is called a logical function because it makes the decision to do ​one of two things based on the value it is testing.

​IF Function

​The IF function is very useful because you can use it to test a condition, and then choose between two actions based on whether the condition is true or false.

​IF Function

The IF function makes use of something called relational operators.

​You may have come across these in your mathematics lessons but it is worth going through what they mean.

​IF Function

Here are some examples of the use of a single IF function:

​

=IF(B3>=50,"Pass","Fail")

​

​This function tests to see if the number in cell B3 is greater than or equal to 50.

​If the answer is true, Pass is displayed and if the answer is false, Fail is displayed.