ExcelHeroThe IFERROR function
Shows a fallback instead of an error.
In German Excel: WENNFEHLER
How to write it
=IFERROR(value, value_if_error)- value
- The formula that might fail.
- value_if_error
- What to show instead.
💡 Great around lookups and divisions.
Try it
Price per item, but the quantity is 0. Show 0 instead of an error.
A
B
C
1
Total
Qty
Per item
2
120
4
3
90
0
Wrap A3/B3 in IFERROR( … , 0).