Very Quick Formula - Any Decimal Rounds Up

LadyGrey26

New Member
Joined
Feb 10, 2006
Messages
47
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.

Thanks so much in advance!

~LG
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Matty

Well-known Member
Joined
Feb 17, 2007
Messages
3,710
Hi,

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

Matty
 

LadyGrey26

New Member
Joined
Feb 10, 2006
Messages
47
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!
 

Matty

Well-known Member
Joined
Feb 17, 2007
Messages
3,710
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
 

scottylad2

Well-known Member
Joined
Feb 2, 2009
Messages
1,919
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
 

Watch MrExcel Video

Forum statistics

Threads
1,132,679
Messages
5,654,712
Members
418,149
Latest member
tjanok

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top