MROUND

[greg2582]

MROUND up does seem to work with in different versions of excel that i've used.
ceiling does/a simlar thing. But if this is a error in excel it needs to be
corrected.
thank you for reading.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...03fe34e&dg=microsoft.public.excel.crashesgpfs

 

[Ken Wright]

It's not MROUND UP, its just MROUND, and performs a different function to
that of CEILING.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------