#DIV/0! error
=IF(denominator_cell=0,0,the_original_formula)
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
wrote in message
...
Hi,
Is there any way to program a formula NOT to show the "#DIV/0!" error
when the formula is referencing a denomentor that is zero? Thanks!
|