two problems with excel 2003

S

Stephen Larivee

I am trying to set up a sheet with some formulas. The cells that contain
the data used by the formulas are now empty. They will be filled over the
next few weeks. I would like to set up the formulas in advance and then be
done with it.

The cells containing the formulas now display #DIV/0! since the cell is
being asked to do computations and there is not data in the cells. "The
formula or function used is dividing by zero or empty cells." Is there a
way to get rid of this message and just see a blank cell or perhaps a Zero
until the numbers are entered?

Also, some of my cells have a small green triangle in the upper left corner.
"The formula in this cell refers to a range that has additional numbers
adjacent to it" Is there a way to get rid of this message? I see how you
can remove the error for one cell, but I have hundred. How do I disable
this error message.

(When I click for Help for this error, Excel comes up with a blank Help box!

TIA
 
R

RWN

The cells containing the formulas now display #DIV/0! since the cell is
being asked to do computations and there is not data in the cells. "The
formula or function used is dividing by zero or empty cells." Is there a
way to get rid of this message and just see a blank cell or perhaps a Zero
until the numbers are entered?
Click to expand...

=if(divisor<>0,whatever/divisor,"")
 
T

tamarakay

Try Tools, Options, Error Checking and uncheck Formula Omits Cells in Region,
but i'm not sure this will fix it. We don't use 2003.
 
Top