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