Microsoft KB Archive/69621

Multiplan: Functions Not Supported in Lotus 1-2-3 PSS ID Number: Q69621 Article last modified on 03-02-1991 PSS database name: D_MPlan

3.00 4.00 4.01 4.20

MS-DOS

Summary:

The following Microsoft Multiplan functions return incorrect values when brought into Lotus 1-2-3.

CHOOSE DOLLAR LOG ROUNDUP COLUMN FACT PRODUCT TEXT COUNTA FIND ROUND TRUNC DDB FIXED ROUNDDOWN WEEKDAY

More Information:

To save Multiplan files in Lotus 1-2-3 versions 2.x format, do the following:


 * 1) Choose Transfer.
 * 2) Select Options.
 * 3) Select Other.

Multiplan has a number of functions that are not supported in Lotus 1-2-3 versions 2.x. Multiplan will try to convert all functions into Lotus 1-2-3 functions; however, if Multiplan cannot match a function perfectly, an error message specifying the cell reference of the location where the error occurred will be displayed. If this error message occurs, Multiplan saves only the displayed value of the formula rather than the formula itself.

Reference(s):

Knowledge base articles Q42768, Q51971, and Q69267.

Copyright Microsoft Corporation 1991.