Rounding Off!?

N

Neo1

Hello, is there a way to round of a number say something like this:

13.2 to 14 instead of going to 13...how can I do this?

Thanks
From John
 
C

Chip Pearson

Use the ROUNDUP function. E.g.,

=ROUNDUP(A1,0)

ROUNDUP is part of the Analysis Tool Pak add-in, so you must have
this loaded to use the function. Go to the Tools menu, choose
Add-Ins, and put a check next to Analysis Tool Pak.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


in message
news:[email protected]...
 
B

Bernard Liengme

Number 13.2 in A1, then both of these give 14
(a) =ROUNDUP(A1,0)
(b) =CEILING(A1,1)
best wishes
 
E

Elkar

You can use the ROUNDUP() function:

=ROUNDUP(A1,0)

Where A1 is your value or formula and the 0 is how many decimal places to
round to.

HTH,
Elkar
 
E

Elkar

Acutally, ROUNDUP is not part of the Analysis ToolPak. Perhaps you're
thinking of MROUND?
 
N

Neo1

The thing is i want to round up the number once it has been divided for
example:

=A1/B1

I want to put that formula on C1 and the number I get there i want to
round it up to the upper number which means if i get say 13.2 i want it
to go to 14 not to 13 for example

From John
Thanks
 
Top