Setting Error #VALUE,#REF,#NAME, etc.

  • Thread starter Thread starter Gulfman100
  • Start date Start date
G

Gulfman100

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?
 
Gulfman100 said:
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?
Click to expand...


I always used to use an IF statement.
 
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.
 
Gordon said:
I always used to use an IF statement.
Click to expand...


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
 
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
 
Thanks Gordon,
I had thought of an IF statement. I was hoping for another way due to the
number of formulas.

Dan
 
Back
Top