Microsoft KB Archive/67177

Multiplan: Use of Logical Functions in an IF Function PSS ID Number: Q67177 Article last modified on 01-10-1991 PSS database name: D_MPlan

1.X 2.X 3.X 4.00 4.01 4.20

MS-DOS

Summary:

If a cell only contains the result of either a TRUE or FALSE logical function (as seen in cell r1c2 in the example below) and that cell is placed in an IF function, one of the following error messages may occur:


 * 1) NAME? error #VALUE! error invalid formula

Example
1              2 1 big IF(rc[-1]=“big”, TRUE, FALSE)

2 IF(r[-1]c= TRUE, 1, 0)

3 IF(r[-2]c= true, 1, 0)

4 IF(r[-3]c= “true”, 1, 0)

In this example, row 2 would give an “invalid formula” message, row 3 would give a “#NAME? error” message, and row 4 would give a “#VALUE! error” message.

These functions return Boolean results and therefore cannot be accessed as normal values. A workaround is to replace the TRUE or FALSE with an actual ASCII character (for example, the numerals 1 and 0, or “true” and “false”).

Copyright Microsoft Corporation 1991.