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.

"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

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

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Maracay" wrote in message
...
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