IF Formula Builder
Build Excel IF formulas step by step — with nested IF support
Step 1 — The condition (logical test)
Use a cell reference (A2, B5) or a value. Put text in "quotes". Numbers and cell refs need no quotes.
Step 2 — Value if the condition is TRUE
Text in "quotes" · Numbers as-is · Another formula or cell reference
Step 3 — Value if the condition is FALSE
Use "" to leave the cell blank when the condition is false
Your IF formula
=IF( … fill in the fields above … )
Master IF, IFS, SUMIF, COUNTIF and more
View course →
Complete Excel course covering logical functions, lookups, pivot tables, and dashboards.
Frequently Asked Questions
-
What is the Excel IF formula syntax?
=IF(logical_test, value_if_true, value_if_false)
logical_test — a condition like A2>100 or B2="Pass"
value_if_true — what to return when the condition is met
value_if_false — what to return when it is not
Text must be in double quotes. Numbers and cell references do not need quotes. -
How do I write an IF with multiple conditions?Use AND or OR inside the IF:
=IF(AND(A2>50, B2="Yes"), "Approved", "Rejected")
AND requires all conditions to be true. OR requires at least one. For multiple outcomes, use the nested IF builder above, or use IFS in Excel 365/2019. -
How do I leave a cell blank in an IF formula?Use two double quotes with nothing between them:
""
Example:=IF(A2>100, "Over budget", "")returns an empty cell when the condition is false. This is cleaner than returning 0 or a space. -
What is IFS and how is it different from nested IF?IFS (Excel 2019 and 365) tests multiple conditions in sequence without nesting:
=IFS(A2>=90,"A", A2>=75,"B", A2>=60,"C", TRUE,"F")
TheTRUEat the end acts as the else clause. IFS is easier to read than deep nesting but is not available in older Excel versions. -
How many IFs can I nest in Excel?Excel allows up to 64 nested IF functions. In practice, more than 3–4 levels is hard to read and debug. For many conditions consider IFS, SWITCH, or a lookup table with VLOOKUP instead.