use of ISERROR
=IF(ISERROR(A2),"",A2)
Iow, you do not need ISERROR on its own in A1
You could also say =IF(ISERROR(C1/D1),"",C1/D1) If say D1 equals 0 or "",
then the cell containing the formula wil have "", else it will show the
outcome, eg C1 = 10, D1 = 2, it will show 5
--
Hth
Kassie Kasselman
"NathanG" wrote:
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
|