error message

[billQ]

Hello,
The formual I am using is:
=SUM(E6:E7)/SUM(B6:B7)
When the page calculates the value I get a little green triangle in the
upper left hand corner. When I click on the cell and place the mouse on the
exclamation point I get the tool tip "The formula in this cell refers to a
range that has additional numbers adjacent to it." I can rid of the
triangle by choosing the Ignore Error option from the popup menu. There are
many rows in the range with the same error. I do not want to have to choose
each one and select Ignore error. Is there a setting that will avoid the
green triangle from appearing?
thanks
bill

 

[Dave Peterson]

There's an option under Tools|Options|Error Checking Tab
where you can toggle the checks that excel2002 does for you (and turn it
completely, too.)