Dealing with #VALUE!
 

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

Dealing with #VALUE!
 

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

Dealing with #VALUE!
 

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

Dealing with #VALUE!
 

=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