Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does my format keep changing in the cell? | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Conditonal Format with a date format | Excel Discussion (Misc queries) | |||
Provide rounding tool that sums correctly | Excel Worksheet Functions | |||
why does currency format change to number format? | Excel Discussion (Misc queries) |