Use the ROUNDUP function. E.g.,
=ROUNDUP(A1,0)
ROUNDUP is part of the Analysis Tool Pak add-in, so you must have
this loaded to use the function. Go to the Tools menu, choose
Add-Ins, and put a check next to Analysis Tool Pak.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Neo1" wrote
in message
...
Hello, is there a way to round of a number say something like
this:
13.2 to 14 instead of going to 13...how can I do this?
Thanks
From John
--
Neo1
------------------------------------------------------------------------
Neo1's Profile:
http://www.excelforum.com/member.php...o&userid=30329
View this thread:
http://www.excelforum.com/showthread...hreadid=520843