How many IF statements can you nest in a Salesforce formula?

There is no separate nesting count. The real limits are 3,900 characters and a 15,000-byte compile size, listed in Salesforce Help: Formula Field Limits . Long chains on one picklist are shorter as CASE.

Does Salesforce have an IF ELSE or ELSEIF function?

No. Put the next IF inside value_if_false of the previous one, as the nested tax-rate example in the Salesforce Help IF reference does. The final value_if_false is your "else".

Can an IF formula return a blank value?

Yes. Use null as value_if_true or value_if_false, for example IF(condition, "PAYMENT OVERDUE", null).

What is the difference between AND() and && in a Salesforce formula?

None in the result. && is the operator form of AND() and || is the operator form of OR(), so pick whichever reads better.

Is ISNULL still supported in Salesforce formulas?

Yes, existing formulas keep working, but Salesforce says to use ISBLANK in new ones because it also supports text fields.

Salesforce IF Formula: Syntax, Nested IF, AND, OR and NOT Examples

Updated October 22, 2026 by Tanya

The Salesforce IF formula tests one condition and returns one value when it is true and another when it is false:

IF(logical_test, value_if_true, value_if_false)

IF works in formula fields, validation rules, approval processes and default values. Below: 11 copyable formulas, NOT on its own, IF versus CASE, and the first two editor errors you will hit. Four formulas ran on five partner accounts in a Winter ’27 Developer Edition org.

This Tutorial Covers: