B
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
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