fx =IF(A1>100,"Yes","No")ABCOrder #1042$1,250ApprovedOrder #1043$450ReviewOrder #1044$3,200Approved
🔀 Logic

IF Formula for Logic

Return different values based on a condition. Copy-paste ready for Excel, Google Sheets, and Airtable.

=IF(A1>100,"Yes","No")
When you need this: When you need to mark whether a test score in A1 exceeds the passing threshold (100 points).

How it works

  1. 1Test a condition (A1>100).
  2. 2If true, return the first value ("Yes").
  3. 3If false, return the second value ("No").

Variations

Nested IF for ranges
=IF(A1>=90,"Pass",IF(A1>=70,"Need Improvement","Fail"))
IF with calculations
=IF(B1="Complete",A1*1.1,A1)

Related Formulas

IFS — Check multiple conditions (cleaner than nested IF)LogicIFERROR — Show a custom value instead of an errorLogicAND / OR — Check if multiple conditions are trueLogicCHOOSE — Return value based on index numberLogic

Need a formula that's not here?

Generate custom formula →