View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
oteixeira oteixeira is offline
external usenet poster
 
Posts: 1
Default 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