Conditional Formatting Question

[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

 

[T. Valko]

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)

 

[Paul]

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.

 

[Paul]

This formula solves my problem.

Thank you.