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

[Guest]

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.

 

[oteixeira]

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.