J
JHL1927
I want to round up a number to the next whole number Ex: Round up 1.2 to 2.0
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
One way:
=CEILING(A1,1)
=CEILING(A1,1)
D
Dave Peterson
Take a look in excel's help for =roundup()
(Don't you hate that?)
(Don't you hate that?)
A
Alan
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.
=ROUNDUP(A1,0)
Look up the ROUND, ROUNDUP and ROUNDDOWN functions in Help, its all there
and pretty well explained,
Regards,
Alan.
B
batfish
enter "round up" in help and it will guide you for athe solution