Rounding up or down decimals to the nearest 5
 

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!

Rounding up or down decimals to the nearest 5
 

try this

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


On Oct 7, 12:43*pm, Michelle Wong
wrote:
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!

Rounding up or down decimals to the nearest 5
 

thanks! yes that worked great

"muddan madhu" wrote:

try this

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


On Oct 7, 12:43 pm, Michelle Wong
wrote:
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!