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

One way:

=CEILING(A1,1)

In article ,
"JHL1927" wrote:

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

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

(Don't you hate that?)

JHL1927 wrote:

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

--

Dave Peterson

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.
"JHL1927" wrote in message
...
I want to round up a number to the next whole number Ex: Round up 1.2 to
2.0

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

"JHL1927" wrote:

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