Combining the ROUND & SUM function

[thirdeye85]

Hello,

I have a question about combining the ROUND function and SUM function.

I understand that the ROUND function works like this:

=ROUND(E10,1) This would round up a decimal place of cell E10.

And a SUM function can work like this.

=SUM(E10*.10) What this function does is multiplies my E10 cell by .10

I would like to combine both of these into one formula and the best i can come up with is below (which does not work).

=SUM(E10*0.10)(ROUND(E10,1))

Basically, I would like to create a function which multiplies the E10 cell by .10 and then rounds up that calculated value.

Thank you for your help!

 

[Sufiyan97]

Try

=ROUND(SUM(E10*0.1),1)

 

[Joe4]

Welcome to the Board!

Try:

=ROUND(E10*0.1,1)

The SUM function serves no purpose here, as you are only working with one cell.
The SUM function is used on a multi-cell range.

Also, not that ROUND does not necessarily Round Up, it could Rown Down too.

 

[Sufiyan97]

The SUM function serves no purpose here, as you are only working with one cell.

Didn't think of that.

 

[thirdeye85]

Thank you guys, this worked like a charm!

 

[Joe4]

You are welcome.
Glad we were able to help!