Function Error result elimination

[Russ]

I have this function: =IF(AR11*AX11=0,"",(AR11*AX11)/60), which is supposed to return a % value. Instead I'm getting this: #VALUE!. Is there a way get rid of this "#VALUE!" and have a blank "Empty String", or 0%?

Thanks,

 

[Frank Kabel]

Hi Russ
have you checked the entries in AR11 and AX11. They may contain text.
So the best way to prevent the #VALUE error is to make sure both cells
only contain numbers (or are empty).

another way would be
=IF(ISERROR(AR11*AX11),"",IF(AR11*AX11=0,"",(AR11*AX11)/60))

HTH
Frank

 

[Peo Sjoblom]

The reason you get a value error is that either AR11 or AX11 is text,
maybe you have a formula in one of them returning a null string ""

=IF(OR(ISTEXT(AR11),ISTEXT(AX11)),0,your_formula)



--

Regards,

Peo Sjoblom

I have this function: =IF(AR11*AX11=0,"",(AR11*AX11)/60), which is

supposed to return a % value. Instead I'm getting this: #VALUE!. Is there a
way get rid of this "#VALUE!" and have a blank "Empty String", or 0%?

 

[Russ]

Thanks, Frank and Peo. You saved me!