IF Formula Builder

Build Excel IF formulas step by step — with nested IF support

Use a cell reference (A2, B5) or a value. Put text in "quotes". Numbers and cell refs need no quotes.
Text in "quotes" · Numbers as-is · Another formula or cell reference
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

Complete Excel course covering logical functions, lookups, pivot tables, and dashboards.

View course →

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")

    The TRUE at 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.