XL97: Natural Language Formula Returns Zero Value (166744)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q166744 SYMPTOMS
When you calculate a formula using column or row labels as a reference in a
natural language formula, the formula returns a zero value.
CAUSE
This problem occurs when you type 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 typed.
WORKAROUND
When you use natural label formulas, do not type formulas in the same
column or row as the label that you are referencing. Instead, type the formula
in a column to the right of and/or in a row below the label that you are
referencing.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
REFERENCES
For more information about natural language formulas, click the Index tab
in Help, type the following text
and then double-click the selected text to go to the "Learn about labels
and names in formulas" topic.
Modification Type: | Major | Last Reviewed: | 10/22/2000 |
---|
Keywords: | kbprb KB166744 |
---|
|