Rounding up or down decimals to the nearest 5

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!
 
M

muddan madhu

try this

suppose u have value in A1 then in B1 put this formula
=CEILING(A1,5)
 

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
Rounding 6
Round Down to the nearest multiple 2
Round time up to nearest :15 2
Round formula 1
Rounding a Calculated Percentage to the Nearest 5 9
Rounding to the nearest 50 cents 4
rounding down to nearest 1/32 3

Top