Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Setting Error #VALUE,#REF,#NAME, etc.
I am working on a work book that I want to use as a template. How do I hide
all of the errors for the formulas in the cells that appear before the data is entered to make the formula function. What would be the best approach? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Setting Error #VALUE,#REF,#NAME, etc.
"Gulfman100" wrote in message
... I am working on a work book that I want to use as a template. How do I hide all of the errors for the formulas in the cells that appear before the data is entered to make the formula function. What would be the best approach? I always used to use an IF statement. -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s) |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Setting Error #VALUE,#REF,#NAME, etc.
Hi,
You could handle each differently depending on what the formula is. Here are two general solutions: 1. =IF(ISERROR(myformula),"",myformula) 2. Select all the cells that return errors in their formula and then choose Format, Conditional Formatting, pick Formula is from the first drop down and in the next box enter the formula =ISERROR(A1) where A1 is the active cell of the selection. Click Format, and on the Font tab set the Font Color to white. You can select all the cells that return errors by pressing F5, Special, Formula and unchecking all by Errors. FYI if you are using 2003 or later you can suppress the printing of errors even if they are displayed by choose File, Page Setup, Sheet tab, and pick <blank beside Cell errors as. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Gulfman100" wrote: I am working on a work book that I want to use as a template. How do I hide all of the errors for the formulas in the cells that appear before the data is entered to make the formula function. What would be the best approach? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Setting Error #VALUE,#REF,#NAME, etc.
"Gordon" wrote in message
... "Gulfman100" wrote in message ... I am working on a work book that I want to use as a template. How do I hide all of the errors for the formulas in the cells that appear before the data is entered to make the formula function. What would be the best approach? I always used to use an IF statement. What I meant to add, before I pushed "send" by mistake, is an example. Say you have a formula in A1 that says "=A2/D2". If D2 is 0 then you get the #DIV/0 error. So in A1 you put "=IF(D2=0,"",A2/D2) HTH -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s) |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Setting Error #VALUE,#REF,#NAME, etc.
Thanks, since I have multiple formulas I will look into hiding the errors. I
had thought of an IF statement but due to the number of formulas I was hoping there was another way. Dan Armstrong "Shane Devenshire" wrote: Hi, You could handle each differently depending on what the formula is. Here are two general solutions: 1. =IF(ISERROR(myformula),"",myformula) 2. Select all the cells that return errors in their formula and then choose Format, Conditional Formatting, pick Formula is from the first drop down and in the next box enter the formula =ISERROR(A1) where A1 is the active cell of the selection. Click Format, and on the Font tab set the Font Color to white. You can select all the cells that return errors by pressing F5, Special, Formula and unchecking all by Errors. FYI if you are using 2003 or later you can suppress the printing of errors even if they are displayed by choose File, Page Setup, Sheet tab, and pick <blank beside Cell errors as. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Gulfman100" wrote: I am working on a work book that I want to use as a template. How do I hide all of the errors for the formulas in the cells that appear before the data is entered to make the formula function. What would be the best approach? |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Setting Error #VALUE,#REF,#NAME, etc.
Thanks Gordon,
I had thought of an IF statement. I was hoping for another way due to the number of formulas. Dan "Gordon" wrote: "Gordon" wrote in message ... "Gulfman100" wrote in message ... I am working on a work book that I want to use as a template. How do I hide all of the errors for the formulas in the cells that appear before the data is entered to make the formula function. What would be the best approach? I always used to use an IF statement. What I meant to add, before I pushed "send" by mistake, is an example. Say you have a formula in A1 that says "=A2/D2". If D2 is 0 then you get the #DIV/0 error. So in A1 you put "=IF(D2=0,"",A2/D2) HTH -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s) |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Setting Error #VALUE,#REF,#NAME, etc.
Gulfman100,
Could you take a moment to close off the response to an earlier query of yours, http://tinyurl.com/bfhrmo -- Max Singapore http://savefile.com/projects/236895 Downloads:23,000 Files:370 Subscribers:66 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error 13 when setting worksheet listbox | Excel Discussion (Misc queries) | |||
error 1004 when setting pivottable.pagefields | Excel Discussion (Misc queries) | |||
Setting to stop error messages from showing? | Excel Discussion (Misc queries) | |||
Error setting shape text property | Charts and Charting in Excel | |||
off-setting points of different series b/c error bars overlap | Charts and Charting in Excel |