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)

In Excel, you can use Natural Language formulas, as explained he

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 InsertNameLabel
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.


arutchelvi wrote:
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)


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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..........

"Debra Dalgleish" wrote:

In Excel, you can use Natural Language formulas, as explained he

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 InsertNameLabel
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.


arutchelvi wrote:
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)


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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."


arutchelvi wrote:
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..........

"Debra Dalgleish" wrote:


In Excel, you can use Natural Language formulas, as explained he

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 InsertNameLabel
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.


arutchelvi wrote:

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)


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html