H
hsaryfm
How to convert 0.1 to 1
or
5.11125 to 6.000
or
5.11125 to 6.000
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.
T
Tyro
If the number is in A1, then in B1 =ROUNDUP(A1,0)
tyro
tyro
C
Chip Pearson
See the ROUNDUP function. E.g.,
=ROUNDUP(0.1,0)
returns 1
=ROUNDUP(5.111,0)
returns 6.
ROUNDUP moves away from zero, which is not necessarily the same as rounding
toward positive. E.g.,
=ROUNDUP(-5.123,0)
returns -6, not -5
--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
=ROUNDUP(0.1,0)
returns 1
=ROUNDUP(5.111,0)
returns 6.
ROUNDUP moves away from zero, which is not necessarily the same as rounding
toward positive. E.g.,
=ROUNDUP(-5.123,0)
returns -6, not -5
--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
T
Tyro
If the number is in A1, then in B1 =ROUNDUP(A1,0)
tyro
tyro
R
Ragdyer
Try this:
=CEILING(A1,1)
=CEILING(A1,1)