ROUNDING UP

Posted by MARCHETTI on January 10, 2002 9:37 AM

how can you round up for example. 12.2 to 13. 11.3 to 12. please advise would be a great help!

Posted by Juan Pablo G. on January 10, 2002 9:43 AM

You can use either one of this:

=ROUNDUP(A1,0)
=INT(A1)+1

The second one always rounds to 0 decimals. To use the first one you must install the Analysis ToolPak addin.

Juan Pablo G.

Posted by IML on January 10, 2002 10:02 AM

Just being picky..

You may want to modify the second formula ever so slightly to
=INT(A1)+1-(A1=INT(A1))

Posted by Juan Pablo G. on January 10, 2002 11:22 AM

Re: Just being picky..

Thanks, that's a good point.

Juan Pablo G.