PRJ2000: Formula Returns 1 or 0 Instead of Yes or No (260496)
The information in this article applies to:
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],"Yes","No")
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.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Major | Last Reviewed: | 10/17/2002 |
|---|
| Keywords: | kbbug KB260496 |
|---|
|