Microsoft KB Archive/129435

= 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.

