ExcelBanter - Rouding to Multiple Decimals

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Rouding to Multiple Decimals (https://www.excelbanter.com/excel-worksheet-functions/207539-rouding-multiple-decimals.html)

Esssa

Rouding to Multiple Decimals

hi

Advice required for rouding values between below ranges:

10.00 - 10.24 = rounded down to 10

10.25 - 10.49 = rounded up to 10.5

10.5 - 10.74 = rounded down to 10.5

10.75 - 10.9 = rounded up to 11

regards
Essa

Glenn

Rouding to Multiple Decimals

Esssa wrote:
hi

Advice required for rouding values between below ranges:

10.00 - 10.24 = rounded down to 10

10.25 - 10.49 = rounded up to 10.5

10.5 - 10.74 = rounded down to 10.5

10.75 - 10.9 = rounded up to 11

regards
Essa

=ROUND(A1*2,0)/2

Pete_UK

Rouding to Multiple Decimals

With your number in A1, try this:

=CEILING(A1-0.24,0.5)

Copy down as required.

Hope this helps.

Pete

On Oct 23, 1:52*pm, Esssa wrote:
hi

Advice required for rouding values between below ranges:

10.00 - 10.24 = rounded down to 10

10.25 - 10.49 = rounded up to 10.5

10.5 - 10.74 = rounded down to 10.5

10.75 - 10.9 = rounded up to 11

regards
Essa

MartinW[_2_]

Rouding to Multiple Decimals

What was wrong with the answers you recieved in your earlier post??

=ROUND(A1/0.5,0)*0.5
=MROUND(A1,0.5)

"Esssa" wrote in message
...

hi

Advice required for rouding values between below ranges:

10.00 - 10.24 = rounded down to 10

10.25 - 10.49 = rounded up to 10.5

10.5 - 10.74 = rounded down to 10.5

10.75 - 10.9 = rounded up to 11

regards
Essa

All times are GMT +1. The time now is 06:00 PM.