Divide a number by 32 then get the value to round to the nearest .5

I need to have a formula to divide a cell by a number then round the answer up to the nearest half

If I have the cell value of 136 (cell J13) then this divided by the 32 = 4.25
I need the answer to round up to 4.5

Any help would be much appreciated

Thanks for that - I tried to use the same formula in another cell as follows but it rounds down

Value in cell is 135 and it needs to be divided by 50, it gives an answer of 2.7 if I do it manually but when I use the formula below it rounds down and not up

MROUND(J6/50,0.5)
it gives the value of 2.5 but manual calculation gives a value of 2.7 so it needs to round up to 3
is there a formula that will set this to always round up to the nearest half

thanks

hi..

have you try Ceiling functions ?

regards

I have not used Ceiling functions before - how would I apply that to my formula to give the correct answer???

This does not work - the value at J6 changes and when it went up to 145 with the formula you provided it gave me a figure of 3.5 but the value it should still return is 3.
Manual calculation of quantity at 145 in stock is 2.9 (value divided by 50) then rounded up answer should return the number 3

hi..

http://office.microsoft.com/en-001/e...010342225.aspx

please try
ceiling(J6/50, 0.5)

regards