In a worksheet formula?

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

Maracay wrote:

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

--

Dave Peterson