my selfmade error was I wrote roundup(33.321,2) instead of roundup(33.321;2).
thanks anyway
nopfusch
"Fredrik Wahlgren" wrote:
"nopfusch" wrote in message
...
I'm not sure if my 1st question was properly posted - we had a power
failure.
Office 97 upgraded to Premium 2000.
4-6 weeks ago I upgradet my XPpro Sp1 to Sp2 and about the same time I
updated the 1st time excel.
I have not used excel since, but today. The straight forward formula
=roundup(33.321,2) creates an error message.
Please help
Regards
nopfusch
=roundup(33321.2,2) works for me. Remove the ".".
/Fredrik
|