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
Bookmarks