Name option

A

arutchelvi

Sir,would u plz exaplin me the label option(i.e)insert->name->label with an
example.(esp. the use of add label range and existing label range)
 
D

Debra Dalgleish

In Excel, you can use Natural Language formulas, as explained here:

http://support.microsoft.com/kb/279412

Using the first example in that article, you could type the following
formula in a cell:

=Product A First Quarter

and the result would be 100.

You can identify the label ranges:
Choose Insert>Name>Label
Select range A2:A4, select Row labels, click Add
Select range B1:C1, select Column labels, click Add
Click OK

Then, in an empty cell, type an equal sign, then click on cell B2
The natural language formula is automatically created.

However, there are limitations to using natural language formulas, and
it's better to use named ranges.
 
A

arutchelvi

sir,
after typing that example, i typed in a cell
=Product A First Quarter
but for me an error (#name?) is showing.i check'd the label name, it is
correct only.i don't to rectify dat error.pls help me..........
 
D

Debra Dalgleish

Make sure you turn on the 'Accept labels in formulas' option, as
described in the Note near the top of that article:

"If you want to make the intersection feature available, click Accept
labels in formulas on the Calculation tab of the Options dialog box."
 
Top