How is the Insert, Name, Label command differnt from Tools, Options,
Calculation, Accept labels in formulas setting and how would you use the
former?

Thanks.

Let me see if i can show you the difference. Name a cell in a spreasheet
with the label "Product". Enter a few figures above it. In the end enter
the formula =sum(Product). You will have the sum of the figures you
entered.

In another cell enter the formula =Product+1. The result will be 1. Now
enter the figure 1000 in anoter cell and name it "Zidane". In another
cell enter the formula =Zidane+1. The result will be 1001.

See the difference?

Hope it helps.


--
oteixeira
------------------------------------------------------------------------
oteixeira's Profile: http://www.excelforum.com/member.php...o&userid=35320
View this thread: http://www.excelforum.com/showthread...hreadid=560666