ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Rounding Sums Format (https://www.excelbanter.com/excel-discussion-misc-queries/49676-rounding-sums-format.html)

[email protected].(donotspam)

Rounding Sums Format
 
I'm using the following formula: =SUM(N25:R25). I want to round the result. I
cannot seem to find the correct way to write this formula. I know how to
round the sum of two numbers. I cannot find an example of rounding the sum of
a series of numbers. I've even tried looking in Execl books and I cann't find
an example.

Thanks for any help.
--
Bob

Barb Reinhardt

=round(sum(n25:r25),0)

Should round it to the nearest integer.

.(donotspam)"
m wrote in message
...
I'm using the following formula: =SUM(N25:R25). I want to round the
result. I
cannot seem to find the correct way to write this formula. I know how to
round the sum of two numbers. I cannot find an example of rounding the sum
of
a series of numbers. I've even tried looking in Execl books and I cann't
find
an example.

Thanks for any help.
--
Bob




[email protected].(donotspam)

Thanks, it worked.
--
Bob


"Barb Reinhardt" wrote:

=round(sum(n25:r25),0)

Should round it to the nearest integer.

.(donotspam)"
m wrote in message
...
I'm using the following formula: =SUM(N25:R25). I want to round the
result. I
cannot seem to find the correct way to write this formula. I know how to
round the sum of two numbers. I cannot find an example of rounding the sum
of
a series of numbers. I've even tried looking in Execl books and I cann't
find
an example.

Thanks for any help.
--
Bob






All times are GMT +1. The time now is 09:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com