Excel rounding to ten

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

Guest

In excel is there a way in formula to set one cell to give the total rounded
to the nearest tens? Total is $338 but I want $340
 
I can only come up with dividing it by 10 first, then rounding it an
then multiplying it again:

=ROUND(338/10;0)*10

Would do the trick
 
You must log in or register to reply here.

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

How to round up to the nearest five 3
rounding up to nearest specified whole number 1
Round formula 1
Round Down to the nearest multiple 2
Average rounded to nearest 0.50 4
advice on rounding or ceilng a 24 hour time value 3
excel 3
how to multiply two values and round the result 5

Back
Top