Help rounding to highest 1/2 number

[bobletcs123]

Hi All,
Need to be able to round a number >1, to the nearest half, rounding up.
0.87 = 1.
1.17=1.5
1.57=2, etc...
My current formula is just doing it to the nearest half (not necessarily the higher half).
I'm sure theres a ceiling in there somewhere, but not sure.

=IF(A2>1, ROUND(AI2-1)*2, 0)/2, 0))

Thanks in advance!!

 

[Joe4]

Need to be able to round a number >1, to the nearest half, rounding up.
0.87 = 1. 1.17=2, 1.57=2, etc...

If you are rounding up to the nearest half, why would 1.17 go up to 2 instead of 1.5?

 

[Joe4]

If you truly need to next 0.5, try:

=CEILING(AI2,0.5)

 

[bobletcs123]

If you are rounding up to the nearest half, why would 1.17 go up to 2 instead of 1.5?

Sorry... had to edit it!
Meant 1.17 = 1.5....

 

[bobletcs123]

If you truly need to next 0.5, try:

=CEILING(AI2,0.5)

Will give it a try... Think I could just change ROUND to ROUNDUP ?

 

[Joe4]

I believe ROUNUP always rounds to whole numbers.
You need to use CEILING or MROUND, as shown here: Rounding in Excel: ROUND, ROUNDUP, ROUNDDOWN, FLOOR, CEILING functions