IntermediateLogic
Syntax
=IFERROR(value, value_if_error)| Argument | What it means |
|---|---|
value | The formula to try. |
value_if_error | What to show if it returns an error. |
Examples with results
Every result below is calculated by the practice engine on the sample data shown, not typed in by hand.
Examples that need no data
=IFERROR(10/0,"Check the divisor")Division by zero turned into a message
Price list (fictional)
| Row | A | B | C |
|---|---|---|---|
| 1 | Code | Product | Price |
| 2 | P-101 | Desk lamp | 24.9 |
| 3 | P-102 | Notebook | 3.5 |
| 4 | P-103 | Mouse | 15 |
| 5 | P-104 | Keyboard | 32 |
| 6 | P-105 | Monitor stand | 21 |
=IFERROR(VLOOKUP("P-999",A2:C6,3,FALSE),"Not found")A code that is not in the list
Try it yourself
Change the formula or switch to other sample data.
Press Calculate to see the result.
The practice box runs in your browser with BDK’s own calculator, which covers about 60 common functions. Cell references work as in Excel (B2, B2:B9). Your formulas are not saved or sent anywhere. For anything unusual, check the result in Excel itself.
How people use IFERROR at work
- Marketing
Conversion rate when a campaign has no leads yet.
Data: Marketing campaigns (fictional)=IFERROR(D2/C2,0) - Sales
Look up a price and show a note if the code is wrong.
Data: Price list (fictional)=IFERROR(VLOOKUP("P-104",A2:C6,3,FALSE),"Unknown code")
Common mistakes and tips
- IFERROR hides every error, including real mistakes in your formula. Only use it where you expect a specific problem.
Works in
All versions of Excel, and Google Sheets.
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.