Function Wizard Inserts Equation as Text in IF() Function
Article ID: 129435
Article Last Modified on 8/15/2005
APPLIES TO
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0c
- Microsoft Excel 5.0 Standard Edition
- Microsoft Excel 5.0a for Macintosh
This article was previously published under Q129435
SYMPTOMS
In the versions of Microsoft Excel listed at the beginning of this article,
if you use a formula as a True or False argument in an IF statement, the
formula may be converted to text.
For example, if you use A2*1000/A3 as the false argument of an IF
statement, it may be entered in the IF statement with quotation marks
around it, as in the following example:
=IF(A1=0,0,"A2*1000/A3")
WORKAROUND
To work around this problem, do either of the following:
- Enter the formula manually
-or-
- Edit the IF statement that is created by the Function Wizard and
remove the quotation marks from the formula.
STATUS
Microsoft has confirmed this to be a problem in the products listed at
the beginning of this article.
REFERENCES
For more information about the Function Wizard, choose the Search button
in Microsoft Excel Help and type:
Additional query words: XL
Keywords: KB129435