Excel IF Function

The IF function allows us to test for a specific condition within a dataset through the use of a logical argument and then returning different values for true or false results.

How to write an IF function

=IF(logical argument, value if true, value if false)

Logical argument – The argument must be criterion that can be evaluated as True or False
Value if true – This can be a number or a text string if written between parentheses.
Value if false – as above

Example of IF function


The formula used in the above example:-


This example allocates a Pass or Fail tag to each candidate based on if they are in the top 8 of the 15 candidates.