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

JHL1927 · 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.

batfish · Oct 27, 2005

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

rounding a number up to a certain ending digit	6	May 4, 2012
Divide a # into 3 #'s rounded to a whole #	9	Feb 7, 2013
Alternate Rounding Up & Down of .50 in a column	5	Jun 2, 2010
Excel does not accept text format!	0	May 19, 2022
Round Function	5	Feb 24, 2010
cell value functioning as whole number in formulas	4	Sep 27, 2009
Organizing a group of notebooks	0	May 12, 2019
Rounding	4	Apr 13, 2010

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

JHL1927

JE McGimpsey

Dave Peterson

Alan

batfish

Ask a Question

Similar Threads