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.