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!
 
Back
Top