# Very Quick Formula - Any Decimal Rounds Up

##### New Member
Hello again. I just need a very quick formula please. I have a column of numbers. The column next to it has the simple formula =A5/14400 but I need that answer to come out in not only a whole number, but if it happens to have a decimal (almost every one will) it needs to round up. For example:

120,010 / 14400 = 8.33

I need that to say 9, not round down to 8.

~LG

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

#### Matty

##### Well-known Member
Hi,

Try enclosing your formula inside the ROUNDUP function, like =ROUNDUP(yourformula,0)

Matty

##### New Member
Awesome! Thanks so much, the second on works like a charm. (The first option, formatting the cells to 0 decimal places, is what I tried first, but Excel automatically rounds anything under .5 down, which was my problem.)

Thank you thank you! Everyone have a good day!

#### VoG

##### Legend
Try

=ROUNDUP(A5/14400,0)

#### Matty

##### Well-known Member
the second on works like a charm. (The first option, formatting the cells to 0 decimal places, is what I tried first, but Excel automatically rounds anything under .5 down, which was my problem.)

My fault for not reading your question properly in the first place (this may explain why I never did great in my exams at school...).

Glad edited solution worked for you!

Matty

##### Well-known Member
the Ceiling function will do as you wish also, you can control what it rounds up to that way. using 1 will round up to the next whole number, or 0.5 to round up to the next half number etc

Excel Workbook
IJ
1012.253
1024.25
1035.9996
1043.111114
1055.246
Course Dates

Replies
3
Views
437
Replies
9
Views
683
Replies
6
Views
360
Replies
6
Views
1K
Replies
1
Views
142

1,171,186
Messages
5,874,243
Members
433,041
Latest member
spongeavenger

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back