How to RoundUp & Sum in same cell? Formulas

[tjroberts44]

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!

 

[VoG]

Hello and welcome to MrExcel.

Try a formula like

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

 

[Andrew Fergus]

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