Excel Formula Builder
Choose a formula type from the sidebar, fill in your cell references, and copy a ready-to-paste Excel formula. Every other template also has its own page with a full reference section; the nested IF builder lives here.
Nested IF
Grade or bucket a value across three tiers with nested IF logic.
Checked first; if true, the first result is returned.
Returned when the first condition is true.
Checked when the first condition is false.
Returned when the second condition is true.
Returned when neither condition is true.
=IF(A2>=90, "A", IF(A2>=80, "B", "C"))Checks Before You Paste
- •Order conditions from the most to the least restrictive.
- •On Excel 2019+ and 365, IFS is easier to read than deep nesting.
- •Keep text results in quotes and numeric results without them.
Frequently Asked Questions
Most will. Where a formula needs a specific version - XLOOKUP, IFS, FILTER, UNIQUE and TEXTSPLIT all do - the checks below the builder say so for the formula you are currently building.
Mostly yes, and the comma separators shown here need no change. The exceptions are called out per formula in the checks below; IMPORTRANGE is Sheets-only, and a few Excel functions differ on edge cases.
No. Formula generators only use the cell references and criteria you type into the form.
Excel requires text and comparison criteria to be quoted, for example "Complete" or ">=100".