ExcelBanter - How do I get a sum to round?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I get a sum to round? (https://www.excelbanter.com/excel-discussion-misc-queries/106203-how-do-i-get-sum-round.html)

tcarman

How do I get a sum to round?

I have my formula, but I need the answer to round? Thanks.

Harald Staff

How do I get a sum to round?

=ROUND(SUM(A1:A10),0)

HTH. Best wishes Harald

"tcarman" skrev i melding
...
I have my formula, but I need the answer to round? Thanks.

Dave F

How do I get a sum to round?

=round(sum(range),number of digits)
--
Brevity is the soul of wit.

"tcarman" wrote:

I have my formula, but I need the answer to round? Thanks.

tcarman

How do I get a sum to round?

Thanks!

"tcarman" wrote:

I have my formula, but I need the answer to round? Thanks.

All times are GMT +1. The time now is 02:43 PM.