XL97: Results Do Not Change After Toggling Transition Formula Evaluation (158540)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q158540 SYMPTOMS
In Microsoft Excel 97, the results of the following functions will not
change when you toggle the Transition Formula Evaluation option from On to
Off, or vice versa:
AVERAGE
MIN
MAX
STDEV
STDEVP
VAR
VARP
COUNT
In earlier versions of Microsoft Excel, the results of the functions can
change when the Transition Formula Evaluation option is toggled.
CAUSE
The calculation behavior of the above functions has changed in Microsoft
Excel 97. These functions now ignore text values and logical values that
are arguments, even when the Transition Formula Evaluation option is
enabled. Earlier versions of Microsoft Excel treat text values that are
arguments as zero, FALSE as 0 (zero) and TRUE as 1 (one) for these
functions when the Transition Formula Evaluation option is enabled.
RESOLUTION
If you would like Microsoft Excel 97 to interpret text values that are
arguments for the above functions as zero, use the appropriate
corresponding "A" function. Several new functions have been added in
Microsoft Excel 97.
STATUS
This behavior is by design of Microsoft Excel 97.
REFERENCES
For more information about switching to Microsoft Excel from Lotus 1-2-3,
click the Index tab in Microsoft Excel Help, type the following text
and then double-click the selected text to go to the "Switch from Lotus 1-
2-3" topic.
Modification Type: | Major | Last Reviewed: | 10/22/2000 |
---|
Keywords: | kbualink97 KB158540 |
---|
|