View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
jd jd is offline
external usenet poster
 
Posts: 91
Default Zeros and #DIV/0!

Thanks for the help,

I also posted the question on "AVERAGE WEEKLY MAXIMUMS" any ideas on that one?
--
JD


"JD" wrote:

In a cell I have formula that uses data from other cells to calculate values.
Before data is entered into those cells I always see either zeros or #DIV/0!
on my spreadsheet. How do fix it so the cell with the formula is empty until
I enter corresponding data in the other cells?

thanks
--
JD