How do I round up fractions to the next whole number?
I want to round up a number to the next whole number Ex: Round up 1.2 to 2.0
|
How do I round up fractions to the next whole number?
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 |
How do I round up fractions to the next whole number?
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 |
How do I round up fractions to the next whole number?
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 |
How do I round up fractions to the next whole number?
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 |
All times are GMT +1. The time now is 10:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com