Dealing with #VALUE!

[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

 

[John Moore]

Can you show an example ,,, sounds like an IFISERROR would fix ,, but post an
example so we can be sure.

 

[Dave Peterson]

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"))

 

[Niek Otten]

=IF(IF(ISERROR(A5),0,A5)>0,"Positive","Zero or Negative")