AI
AI for Excel
Features
Pricing
Download
Blog
Get the add-in
Home
›
Blog
› Excel Formulas
Excel Formulas
Write, understand, and debug Excel formulas — from IFERROR to XLOOKUP.
Excel Formulas
Excel Formulas · July 1, 2026 · 3 min read
IFERROR + XLOOKUP: Building Error-Proof Excel Formulas
When to use IFERROR, IFNA, and XLOOKUP's if_not_found argument — and when hiding errors is exactly the wrong move. Practical patterns for formulas that fail loudly only when they should.
Excel Formulas
Excel Formulas · June 25, 2026 · 4 min read
Write Excel Formulas in Plain English: How AI Formula Generation Actually Works
Describe what you want in a sentence and get a working, checkable Excel formula written into your sheet. What AI formula generation does well, where it fails, and how to verify the output.