The information in this article applies to:
SYMPTOMSWhen you calculate a formula using column or row labels as a reference in a natural language formula, the formula returns a zero value. CAUSEThis problem occurs when you enter the formula in the same column or row as the label that you are referencing. Natural language formulas seek out the label you are referencing by first searching to the left and then searching above the formula you entered. WORKAROUNDWhen you use natural label formulas, do not enter formulas in the same column or row as the label you are referencing. Instead, enter the formula in a column to the right of or in a row below the label that you are referencing. STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. MORE INFORMATIONWhen you use natural language formulas, it is not necessary to create defined names or determine the cell ranges in advance. Microsoft Excel 98 determines the range based on the row and column labels that you provide in the table on the worksheet. ExampleTo set up the example, type the following data in a worksheet:
In this example, the following formula returns the value 150 for the sum of
Product A:
= Sum('Product A')However, this formula returns a 0 (zero) if you enter it in column A (for example, in cell A5). For additional information about using natural language formulas, please see the following article in the Microsoft Knowledge Base: Q161881 XL97: How to Use Natural Language Formulas REFERENCESFor more information about natural language formulas, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text fomulas, namesand then click Show Topics. Select the "About labels and names in formulas" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant. Additional query words: NLF XL98
Keywords : kbdta xlformula |
Last Reviewed: January 13, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |