How do I round up fractions to the next whole number?

Guest · Oct 27, 2005

I want to round up a number to the next whole number Ex: Round up 1.2 to 2.0

JE McGimpsey · Oct 27, 2005

One way:

=CEILING(A1,1)

Dave Peterson · Oct 27, 2005

Take a look in excel's help for =roundup()

(Don't you hate that?)

Alan · Oct 27, 2005

With 1.2 in A1, in B1 enter:
=ROUNDUP(A1,0)
Look up the ROUND, ROUNDUP and ROUNDDOWN functions in Help, its all there
and pretty well explained,
Regards,
Alan.

Guest · Oct 27, 2005

enter "round up" in help and it will guide you for athe solution

Alternate Rounding Up & Down of .50 in a column	5	Jun 2, 2010
Round Function	5	Feb 24, 2010
Round up to next .5	5	Nov 6, 2008
Round down numbers	4	Jan 20, 2006
Convert inches & display as Feet Inches and Fractions -- BUG FREE	9	Nov 25, 2008
Need formula to round number up to always end in X.X9	6	Nov 12, 2009
IF and Round	5	Mar 11, 2009
Excel 2007 - Rounddown Function?	2	Apr 11, 2008

How do I round up fractions to the next whole number?

Guest

JE McGimpsey

Dave Peterson

Alan

Guest

Ask a Question

Similar Threads