Dealing with #VALUE!

  • Thread starter Thread starter Maracay
  • Start date Start date
M

Maracay

Hi guys,

I created a function but in some rows I got a number and in other I got a
#VALUE!, that is OK, now I need to ask if cell > 0 then do this if not do
that, but look like because the #VALUE! I am getting, the IF function is not
working properly, my question is how can I deal with #VALUE!, if I could make
#VALUE! Zero or “ “ depending on the case could be great

Thanks
 
Can you show an example ,,, sounds like an IFISERROR would fix ,, but post an
example so we can be sure.
 
In a worksheet formula?

=if(iserror(a1),"some kind of error",
if(isnumber(a1),if(a1>0,"greater than 0","not greater than 0"),
"not a number"))
 
Back
Top