Make decisions
Hide errors such as #DIV/0! or #N/A
=IFERROR(A2/B2,0)How it works in Excel
- A2/B2 is the formula you want to run.
- 0 is what shows if it gives an error.
- Use "" in place of 0 to show a blank cell.
- It hides every kind of error, including real mistakes, so use it with care.
- IFNA only hides #N/A, which is safer around lookups.
The idea in general
It is a backup plan: try this, and if it fails, use this instead.
What I assumed
- You are dividing A2 by B2. Swap in your own formula.
Check the result on your own data before relying on it.