Microsoft KB Archive/260496

= PRJ2000: Formula Returns 1 or 0 Instead of Yes or No =

Article ID: 260496

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Project 2000 Standard Edition

-



This article was previously published under Q260496



SYMPTOMS
In Microsoft Project, when you use a field that displays either Yes or No in a formula, such as a Flag field, the field returns a value of 1 or 0, not Yes or No.



WORKAROUND
To work around this problem, use the appropriate method for your situation.

Method 1: Display True or False
To display True or False in a field as a result of a formula, create a formula to return True or False for the corresponding 1 or 0 values. To do this, use either of the following methods:  Reference the flag field in a string operation. For example, use an ampersand (&) to concatenate the field value with another value.

-or-  Force the field to be string data, by using the Str function, for example: Str([Flag1]) 

Method 2: Display Yes or No
To display Yes or No in a field as a result of the formula, create a formula to return Yes or No for the corresponding 1 or 0 values. You can use the IIf function to return Yes or No, for example: IIf([Flag1],&quot;Yes&quot;,&quot;No&quot;)

Method 3: Test for 1 or 0
To correct a formula that tests for True or False, or Yes or No, modify your formula to test for either 1 or 0 instead.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbbug kbpending KB260496

-

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

© Microsoft Corporation. All rights reserved.