Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding formulas | Excel Discussion (Misc queries) | |||
HIDING FORMULAS | Excel Discussion (Misc queries) | |||
Inexplicable VBA errors in formulas | Excel Discussion (Misc queries) | |||
Handling errors in formulas (how annoying are they!) | Excel Discussion (Misc queries) | |||
Errors in copying formulas | Excel Discussion (Misc queries) |