Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does label do under Insert, Name, Label?
What does label do under Insert Name Label? Will you please give me an
example? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does label do under Insert, Name, Label?
have a look at 'About labels and names in formulas ' in the help.
It basically takes the row or column heading as the label for the row or column and uses that name in the formulas. You have to turn on the application by toolsoptionscalculationsuse labels check box -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "trainer07" wrote: What does label do under Insert Name Label? Will you please give me an example? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does label do under Insert, Name, Label?
Hi
Using existing row and column labels as names When you create a formula that refers to data in a worksheet, you can use the column and row labels in the worksheet to refer to the data. For example, to calculate the total value for the Product column, use the formula =SUM(Product). Using a label Or if you need to refer to the Product 3 amount for the East division (that is, the value 110.00), you can use the formula =Product 3 East. The space in the formula between "Product 3" and "East" is the intersection operator. This operator designates that Microsoft Excel should find and return the value in the cell at the intersection of the row labeled East and the column labeled Product 3. Note By default, Excel does not recognize labels in formulas. To use labels in formulas, click Options on the Tools menu, and then click the Calculation tab. Under Workbook options, select the Accept labels in formulas check box. Stacked labels When you use labels for the columns and rows on your worksheet, you can use those labels to create formulas that refer to data on the worksheet. If your worksheet contains stacked column labels€” in which a label in one cell is followed by one or more labels below it€” you can use the stacked labels in formulas to refer to data on the worksheet. For example, if the label West is in cell E5 and the label Projected is in cell E6, the formula =SUM(West Projected) returns the total value for the West Projected column. The order for stacked labels When you refer to information by using stacked labels, you refer to the information in the order in which the labels appear, from top to bottom. If the label West is in cell F5 and the label Actual is in cell F6, you can refer to the actual figures for West by using West Actual in a formula. For example, to calculate the average of the actual figures for West, use the formula =AVERAGE(West Actual). Using dates as labels When you label a range by using the Label Ranges dialog box and the range contains a year or date as a label, Excel defines the date as a label by placing single quotation marks around the label when you type the label in a formula. For example, suppose your worksheet contains the labels 2007 and 2008 and you have specified these labels by using the Label Ranges dialog box. When you type the formula =SUM(2008), Excel automatically updates the formula to =SUM('2008'). Challa Prabhu "trainer07" wrote: What does label do under Insert Name Label? Will you please give me an example? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to rezize data label box in pie charts (label wraps to two lin | Charts and Charting in Excel | |||
Insert | Name | Label | Excel Discussion (Misc queries) | |||
COPY LABEL FORM FROM EXCEL TO A LABEL | New Users to Excel | |||
What does Insert>name>LABEL option do ? | Excel Discussion (Misc queries) | |||
how to remove label formatting (eg label to number) | Excel Worksheet Functions |