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

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