how is Insert, Name, Label different frm Accept labels in formula
 

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.

how is Insert, Name, Label different frm Accept labels in formula
 

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