IF Formula Generator
Build Excel IF statements - and nested IF logic - by filling in the condition and the results for true and false.
IF
Return one value when a condition is true and another when it is false.
A comparison that is TRUE or FALSE, for example A2>=60.
Result when the condition is true. Text needs quotes.
Result when the condition is false. Text needs quotes.
=IF(A2>=60, "Pass", "Fail")Checks Before You Paste
- •Wrap text results in quotes, for example "Pass".
- •Nest another IF in the false slot to test more cases, or use IFS.
- •Use >=, <=, or <> inside the condition to compare values.