Create a Basic IF Statement

Make a formula that decides between two results based on a condition.

You will learn to

• Write a logical test like B2>=60
• Return text or numbers with IF
• Use quotes around text results

How it works

IF checks a condition and returns one value when it is TRUE and another when it is FALSE: =IF(B2>=60,"Pass","Fail"). Text results go in double quotes. Comparison operators include =, <>, >, <, >= and <=.

=IF(B2>=60,"Pass","Fail")