Function Error result elimination

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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
 
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


Russ said:
I have this function: =IF(AR11*AX11=0,"",(AR11*AX11)/60), which is
Click to expand...
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%?
 
Back
Top