# How to RoundUp & Sum in same cell? Formulas

#### tjroberts44

##### New Member
Hi. I'm a basic excel user and have a question about formulas. In one cell I plugged in the SUM formula to add numbers from 3 different cells. My question is, can I also plug in a ROUNDUP formula in the same SUM cell?
Basically, I want my SUM number to also be rounded up. Thanks!

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

#### VoG

##### Legend
Hello and welcome to MrExcel.

Try a formula like

=ROUNDUP(SUM(A1:A3),0)

#### Andrew Fergus

##### MrExcel MVP
Hi and welcome to MrExcel!

Yes you can put functions inside other functions. For instance, to round the sum up (to one decimal place) you would put one function inside another like this:

=ROUNDUP(SUM(A1, B2, C3),1)

If you search this board you will find many many examples of functions nested inside other functions.

Andrew

Replies
3
Views
193
Replies
2
Views
425
Replies
7
Views
162
Replies
0
Views
160
Replies
12
Views
241

1,191,187
Messages
5,985,191
Members
439,947
Latest member
fabiannic

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