Function Wizard Inserts Equation as Text in IF() Function (129435)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for Windows NT 5.0
- Microsoft Excel for the Macintosh 5.0a
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:
| Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
|---|
| Keywords: | KB129435 |
|---|
|