Microsoft KB Archive/25319

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 18:19, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q25319 to Microsoft KB Archive/25319 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Round Function Not Converted to Lotus 1-2-3 PSS ID Number: Q25319 Article last modified on 02-24-1988 PSS database name: D_MPlan

3.0 3.01 3.02 3.04


Problem: I am saving a spreadsheet with Transfer Options set to Other so I can load the file into Lotus. The file contains several Round() functions. When I try to save, Multiplan emits the message, “Not a Valid Formula.”

Response: If you have a Multiplan spreadsheet that contains a Round() function, Multiplan will not convert the Round() function into a formula that Lotus can understand. The Round() function was not included among the functions that can be converted to Lotus. If the spreadsheet contains a Round() function and you save it with Transfer Options set to Other, Multiplan will give the message,“Not a Valid Formula,” which refers to the cells that contain this function. The file is still saved to a format Lotus will read, but the cells that formerly contained a Round() function will contain only the rounded value.

Copyright Microsoft Corporation 1988.