IF in Excel: Syntax, Examples and Errors

Syntax

=IF(logical_test, value_if_true, [value_if_false])

Depending on your regional settings, arguments are separated by semicolons instead of commas: =IF(B2>=50; "Pass"; "Fail"). This is standard in countries where the comma is the decimal separator.

Basic examples

=IF(B2>=50, "Pass", "Fail")

The classic pass/fail test: every score of 50 or more shows Pass, everything below shows Fail. Text results always need double quotes, and the comparison operators (=, <>, >, >=, <, <=) sit inside the logical test, not in the result.

=IF(C2>1000, C2*0.1, 0)

A 10% commission above 1,000, zero otherwise. Both results here are calculations, so no quotes anywhere — IF can return any formula, not just fixed values.

=IF(D2="", "Missing", D2*1.2)

Checks for an empty cell first and flags it, otherwise runs the markup. Testing against "" is the standard way to catch blanks before doing math on them.

=IF(E2="Done", "Closed", "")

Labels finished rows and leaves the rest truly blank. The empty quotes are what make the cell look empty — leaving the third argument out would print FALSE instead.

Numbers as results must not be quoted: =IF(A1>0, "50", 0) returns the text "50", which SUM and AVERAGE silently skip. Quote only text results; keep numbers, dates and formulas bare.

Common errors and how to fix them

Invisible spaces cause the equal-text trap too: =IF(C2="Paid", ...) misses "Paid " with a trailing space. Clean the column first, then the comparison matches.

• Trim whitespace in ExcelRemoves invisible spaces that silently break text comparisons inside IF.
• Convert text to numbersFixes numbers stored as text that ruin numeric comparisons and results.

Nested IF vs. IFS

=IF(B2>=90, "A", IF(B2>=80, "B", IF(B2>=70, "C", "F")))

The classic grade ladder: each condition falls through to the next IF when it fails. Read it inside-out, and mind that the closing parentheses pile up at the end — three nested IFs end with three of them.

=IFS(B2>=90, "A", B2>=80, "B", B2>=70, "C", TRUE, "F")

The same ladder in IFS: condition and result alternate as flat pairs, evaluated in order. There is no built-in else — the TRUE, "F" pair at the end acts as the catch-all, exactly like the last IF above.

IF in Google Sheets

Google Sheets supports IF with the same arguments and behavior as Excel, so the formulas above can be pasted over unchanged.

• The optional third argument behaves identically: omit it and Sheets also returns FALSE, not a blank.
• In regional settings that use a comma as the decimal separator (much of Europe and Latin America), type semicolons between arguments: =IF(B2>=50; "Pass"; "Fail"). Excel behaves the same way.
• Sheets also offers IFS with the same no-default-else quirk — end the list with TRUE, fallback to cover every remaining case.
• For many branches, both apps offer SWITCH, which compares one cell against a list of values and is far more readable than a deep IF ladder.

Limitations and pro tips

• IF returns a value; it cannot perform an action or "do nothing". For conditional formatting, filtering or deleting rows, use those features directly instead of an IF wrapper.
• Beyond 3-4 nested levels, switch to IFS, or replace the whole ladder with a lookup: =VLOOKUP(B2, $F$2:$G$5, 2, TRUE) maps score bands to grades in one row.
• Do not quote numeric results — quoted numbers become text and drop out of SUM, AVERAGE and charts.
• Omitting the third argument yields FALSE, not an empty cell: write "" explicitly when the blank look is the goal.
• Glue text and cells with &: =IF(B2>=50, "Passed with "&B2, "Failed with "&B2) builds a dynamic message without extra columns.

IF is only as reliable as the data it tests. Validate the column first — blanks, text-numbers and duplicates all silently flip results — then let the formula do its job.

• Validate Excel dataScans for blanks, text-numbers and duplicates that quietly skew IF results.
• Analyze Excel data onlineColumn-by-column health check before you build logic on top of the data.