View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jay Jay is offline
external usenet poster
 
Posts: 671
Default 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,