Learn how to use IF statements in Microsoft Excel to return output based on the contents of another cell.
=IF(Logical Test,Value if True, Value if False)
Logical Test: Equality/Inequality statement on which the outcome is decided
Value if True: What action occurs of the logical test is true
Value if False: What action occurs of the logical test is false
| Operator | Meaning (Example) |
|---|---|
| "=" (equal to) | Equal to (A1=B1) |
| >(greater than) | Greater than (A1>B1) |
| < (less than) | Less than (A1 |
| >= (greater than or equal to) | Greater than or equal to (A1>=B1) |
| <= (less than or equal to) | Less than or equal to (A1<=B1) |
| <> (not equal to) | Not equal to (A1<>B1) |
Learn More About Excel
Become an expert in Excel through our Microsoft Office training and Excel courses. We offer flexible scheduling and small class sizes, so sign up today!