Microsoft KB Archive/36013

Works Cannot Return Strings from the IF Function

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

1.00 1.05 2.00

MS-DOS

= SUMMARY =

In Microsoft Works for MS-DOS, the IF function, and any other formula or function, does not allow a string of text to be displayed as the result of a conditional statement.

For example, if Field1 contains the entry 100, the formula =IF(Field1=100,“One Hundred”,“Not One Hundred”) is not a valid formula.

Moreover, if cell A3 contains the text entry “Fred”, the formula =A3 will return a value of 0. This is because text strings cannot be evaluated in a formula, and are assigned a numerical value of 0.

Works cannot return a string (text) value in any formula or function. This feature is under review and will be considered for inclusion in a future release of Works.

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 1.0 2.0 1.00 1.05 2.00 =

Copyright Microsoft Corporation 1996.