Retrun "" (blank)
 

Hey guys:

I need a bit of assistance to eliminate the #Value! error message in these 2
formulas if there is no data in the cell's being calculated! Is this
possible? Here are the formulas as I have them working; (1)
=IF(ISERROR($G$5/12)=0,"",$G$5/12)
(2) =IF($H$5="","",$V$5/COUNT($H$5:$S$5))

If so, how?

Thanks,

Retrun "" (blank)
 

Is formula 2 dependent on formula 1?

Just remove the =0 portion from formula 1 or flip the value_if_true and
value_if_false arguments if you intentionally want it to work that way:

=IF(ISERROR($G$5/12),"",$G$5/12)

=IF(ISERROR($G$5/12)=0,$G$5/12,"")

Biff

"Jay" wrote in message
...
Hey guys:

I need a bit of assistance to eliminate the #Value! error message in these
2
formulas if there is no data in the cell's being calculated! Is this
possible? Here are the formulas as I have them working; (1)
=IF(ISERROR($G$5/12)=0,"",$G$5/12)
(2) =IF($H$5="","",$V$5/COUNT($H$5:$S$5))

If so, how?

Thanks,