Microsoft KB Archive/160543

= XL97: Error Evaluating Natural Language Formula =

Article ID: 160543

Article Last Modified on 10/19/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q160543



SYMPTOMS
When you attempt to evaluate part of a natural language formula in the formula bar (by pressing F2, and then pressing F9), the follow message may appear:

The formula you typed contains an error.



CAUSE
This behavior occurs because Microsoft cannot resolve the label as an address, and Microsoft Excel fails to evaluate the formula. Note that a label is not a cell address; if you try to evaluate a label in the formula bar, the error message appears.



STATUS
This behavior is by design of Microsoft Excel 97 for Windows.

Additional query words: XL97 English

Keywords: kberrmsg KB160543

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.