PDA

View Full Version : Replace #DIV/0! ERROR as blank cell


cosmicsyzygy
08-27-2007, 08:06 AM
Hello

I am working an a productivity tracker that records transactions completed on a daily basis, giving a weekly and monthly total. It also calulates daily productivity numbers. On some days, there is no data and the cell remains blank. Unfortunately, this gives me the above error and that affects the monthly total. The spreadsheet is protected and allows data only for transaction completed. Is there a way to work around this without giving access?

Thanks in advance for any help.
CosmicSyzygy
Bob Phillips
08-27-2007, 08:17 AM
=IF(ISNUMBER(your_formula),your_formula,"Incomplete data")
cosmicsyzygy
08-27-2007, 08:39 AM
=IF(ISNUMBER(your_formula),your_formula,"Incomplete data")
Thank you so much for the quick response... My issue has been resolved!:thumb
RonMcK
08-27-2007, 09:22 AM
=IF(ISNUMBER(your_formula),your_formula,"Incomplete data")
I usually set the null case to "" and only use a msg like "Incomplete data" when data must be entered in the cell. Besides a 'cleaner' worksheet, this reduces the number of questions from users of the worksheet.

Ron
Orlando, FL