use of ISERROR
If the source is legitimately 0, you could use a formula like
=IF(M1=0,"",N1/M1)
which is far better than using ISERROR IMO.
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"Bob Phillips" wrote in message
...
Are you sure that masking errors is a good idea? Wouldn't it be wise to
check out why you get the #DIV/0?
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"NathanG" wrote in message
...
Hi,
A customer has asked me to supress any hashes. Typically the error is
#div/0!
I tried iserror(a2) and it came back true. If I change the value its
false
so that works. The thing is hiding the #div/0! and hiding the result of
the
iserror.
So I need another formula with this logic
if a2 is #div/0! then
a2 = ""
else if
a2 = the value of A2 ( it can contain a number)
and a1 (the result of Iserror)
= "" (all the time no matter if is true or false)
Thanks
Nathan
|