Microsoft KB Archive/66997

Works 2.0: IF Function Does Not Allow Text String

PSS ID Number: Q66997 Article last modified on 06-12-1996

1.00 1.05 2.00

MS-DOS

= SUMMARY =

In the Database module and the Spreadsheet module of Works versions 2.0 and earlier, the IF function will NOT allow a string of text to be the result of a conditional statement. The only alphanumeric result these versions of Works can produce are TRUE, FALSE, and NA. All other results must be numeric. The numbers 0 and 1 can be used for TRUE and FALSE. In either case, the column must be formatted for TRUE/FALSE.

Example
=IF(A1=3,TRUE,NA)

= MORE INFORMATION =

Works version 3.0 allows text as the result of an IF function.

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 1.00 1.05 2.00 3.00 =

Copyright Microsoft Corporation 1996.