W
willstevenson
I am trying to migrate Lotus 123 (.WK4) files to Excel 2000.
Macros have been rewritten in VBA, nested (if) statements rewritten s
as not to be > 7 levels, but the one simple function that doesn't see
to readily migrate is @ROUNDUP.
Copying and pasting the function out of 123 and into Excel and it work
fine.
E.g. @ROUNDUP(1.5, 0) returns 2 in 123
ROUNDUP(1.5, 0) returns 2 in Excel.
However opening a .WK4 file with this function in Excel gives 'Canno
read record' error and, on clicking OK, cell comments 'Formula faile
to convert'.
So...
Am I missing something simple?
And/or would it open ok in a later version of Excel?
Thanks in advance..
Macros have been rewritten in VBA, nested (if) statements rewritten s
as not to be > 7 levels, but the one simple function that doesn't see
to readily migrate is @ROUNDUP.
Copying and pasting the function out of 123 and into Excel and it work
fine.
E.g. @ROUNDUP(1.5, 0) returns 2 in 123
ROUNDUP(1.5, 0) returns 2 in Excel.
However opening a .WK4 file with this function in Excel gives 'Canno
read record' error and, on clicking OK, cell comments 'Formula faile
to convert'.
So...
Am I missing something simple?
And/or would it open ok in a later version of Excel?
Thanks in advance..