Rounding off or Converting Numbers
 

How to convert 0.1 to 1

or

5.11125 to 6.000

Rounding off or Converting Numbers
 

If the number is in A1, then in B1 =ROUNDUP(A1,0)

tyro

"hsaryfm" wrote in message
...
How to convert 0.1 to 1

or

5.11125 to 6.000

Rounding off or Converting Numbers
 

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)

"hsaryfm" wrote in message
...
How to convert 0.1 to 1

or

5.11125 to 6.000

Rounding off or Converting Numbers
 

If the number is in A1, then in B1 =ROUNDUP(A1,0)

tyro

"hsaryfm" wrote in message
...
How to convert 0.1 to 1

or

5.11125 to 6.000

Rounding off or Converting Numbers
 

Try this:

=CEILING(A1,1)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"hsaryfm" wrote in message
...
How to convert 0.1 to 1

or

5.11125 to 6.000