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 |
=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 |
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