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
=IF(ISNUMBER(your_formula),your_formula,"Incomplete data")
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thank you so much for the quick response... My issue has been resolved!Originally Posted by xld
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
Posting Permissions
Reply With Quote
