# Round sum formula request

#### Muthukrishnan V

##### Board Regular
Excel 2003 - Column C contains numericals. I want the output of
C15 * 15% (Rounded up), for example if C15 * 15% is 63292.64, I want the output to be 63293 in Column C16. What formula should I use in C16? Please help.

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### VoG

##### Legend
Try

=ROUNDUP(B15*0.15,0)

#### Banker1

##### Active Member
Try

=ROUNDUP(B15*0.15,0)

Note that this formula will round all values up to the next integer (i.e., 6.4 rounds to 7 as does 6.6). If you want to round to the nearest integer use ROUND() therefore 6.4 will round to 6 and 6.6 will round to 7.

Replies
0
Views
159
Replies
2
Views
219
Replies
1
Views
562
Replies
3
Views
191
Replies
1
Views
260

1,190,637
Messages
5,982,055
Members
439,752
Latest member
jscratch

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