# Help with number rounding

#### Sithlife

##### New Member
Hello,

I am trying to calculate numbers using the sum function but sometimes they don't come out whole.

I really need them to round UP to the nearest number - how do I do this when using a formula to get the result?

E.G - =SUM(D7/2)

### Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

#### pgc01

##### MrExcel MVP
Hi

Check the help on the function

ROUNDUP()

Too late.

#### Jim885

##### Well-known Member
Your actual formula will be this ...

=ROUNDUP(SUM(D7/2),0.5)

#### grd

##### Board Regular
Personally, I wouldn't use SUM as it is superfluous in that example!

#### pgc01

##### MrExcel MVP
Your actual formula will be this ...

=ROUNDUP(SUM(D7/2),0.5)

Hi Jim

The second parameter of RoundUp() is an integer.

Replies
2
Views
71
Replies
5
Views
89
Replies
10
Views
490
Replies
4
Views
136
Replies
14
Views
226

1,196,027
Messages
6,012,950
Members
441,740
Latest member
abaz21

### 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