Rounding Sums Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=round(sum(n25:r25),0)

Should round it to the nearest integer.

"(e-mail address removed).(donotspam)"
 
Thanks, it worked.
--
Bob


Barb Reinhardt said:
=round(sum(n25:r25),0)

Should round it to the nearest integer.

"(e-mail address removed).(donotspam)"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

office 2003 Excel - SUM 3
rounding a formula with sum 5
SUM - IF - AND 7
Sum + Round Up 2
How not to round a formula 9
How to remove automated rounding? 6
Excel 2007 - RoundDown in Calculation? 4
Round formula 1

Back
Top