Microsoft KB Archive/60356

Multiplan 4.20: Using an IF Statement in Macros PSS ID Number: Q60356 Article last modified on 04-19-1990 PSS database name: D_MPlan

4.20

MS-DOS

Summary:

On Page 166 of the “Microsoft Multiplan User’s Guide” for Multiplan Version 4.2, there is an example of the ‘IF ’. The example given is as follows:

‘IFAND(R1C1>0,R1C1<4)&quot;GOR100C100’

This statement will fail for the following two reasons:


 * 1) In this case, the AND function must be surrounded by parentheses.
 * 2) The double quotation mark should be two single quotation marks.

The statement shown below should be entered in Alpha mode:

‘IF(AND(R1C1>0,R1C1<4))’‘GOR100C100’

For instance, if the macro is started and R1C1 is set to 3, the macro will branch to the macro statements in R100C100.

Copyright Microsoft Corporation 1990.