View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kati Kati is offline
external usenet poster
 
Posts: 5
Default Hiding Errors for formulas

I am trying to create a workbook with multiple worksheets that utilizes only
one data sheet and has the formulas already in place so that someone else can
fill in just the hard data numbers and get the information out of the
formulas. Because it is for a at least a year and we only have 1 months worth
of data, it is giving me =DIVD/0! errors. Can I hide the error message so
that the formula stays inside each cell but fills when the data sheet is
filled?
Thanks!