Rounding up or down decimals to the nearest 5

  • Thread starter Thread starter Michelle Wong
  • Start date Start date
M

Michelle Wong

Hi

what formula can I use to round up a number with decimals to the nearest 5? eg
368.10 would be 370
367.00 would be 370
366.20 would be 370
364.12 would be 365
361.42 would be 365

I tried using various combinations of round, roundup and mround, but can't
seem to get it right...
thanks in advance!
 

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

rounding up to nearest specified whole number 1
Round Down to the nearest multiple 2
Round time up to nearest :15 2
Round time to nearest 15 minutes in decimal format 4
Round formula 1
Round to nearest multiple 3
Rounding decimals up or down 3
Round Number to Nearest 50 3

Back
Top