Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hiding a formula error
Hello,
I have a worksheet that is a "total" sheet for 2 other worksheets. I put the formula = then reference the other worksheet specific cell. I will not fill in the 2nd sheet for 2 weeks. On the total sheet is shows as #REF!. How can I hide that #REF! until the 2nd sheet is filled in? Thanks -- Kim |
#2
|
|||
|
|||
Hi
try =IF(ISERROR(your_formula),"",your_formula) -- Regards Frank Kabel Frankfurt, Germany "Kim" schrieb im Newsbeitrag ... Hello, I have a worksheet that is a "total" sheet for 2 other worksheets. I put the formula = then reference the other worksheet specific cell. I will not fill in the 2nd sheet for 2 weeks. On the total sheet is shows as #REF!. How can I hide that #REF! until the 2nd sheet is filled in? Thanks -- Kim |
#3
|
|||
|
|||
Kim
I don't understand why you would be getting #REF! error by just referring/linking to an empty cell on another sheet. You have something else going on. The cell or sheet reference is incorrect. Gord Dibben Excel MVP On Tue, 30 Nov 2004 20:38:23 +0100, "Frank Kabel" wrote: Hi try =IF(ISERROR(your_formula),"",your_formula) -- Regards Frank Kabel Frankfurt, Germany "Kim" schrieb im Newsbeitrag ... Hello, I have a worksheet that is a "total" sheet for 2 other worksheets. I put the formula = then reference the other worksheet specific cell. I will not fill in the 2nd sheet for 2 weeks. On the total sheet is shows as #REF!. How can I hide that #REF! until the 2nd sheet is filled in? Thanks -- Kim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL ERROR - series formula is too long | Excel Worksheet Functions | |||
Formula Error | Excel Discussion (Misc queries) | |||
Error in a formula | Excel Discussion (Misc queries) | |||
Formula Error | Excel Discussion (Misc queries) | |||
Formula error | Excel Worksheet Functions |