Conditional Formatting Question

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I have a computation that returns #DIV/0!

It does that because I'm dividing by 0 I assume.

Is there a way to make the #DIV/0! show up as either a blank cell, or
better yet simply a 0?

Thanks
 
It would have given us a better idea of what to suggest if you had posted
your actual formula.

The generic approach:

=IF(ISERROR(your_formula_here),0,your_formula_here)
 
I figured out how to make the cell come up blank (with Excel 07), but
I'm still at a loss to how to make it come up with a 0.
 
Back
Top