Round up to next .5
Thanks guys!
"Pete_UK" wrote:
Try this:
=CEILING(A1,0.5)
Hope this helps.
Pete
On Nov 6, 3:21 pm, LKP wrote:
I am trying to find a formula that will round a number up to the next .5. I
have tried MROUND which gets it to a number that ends in .5, but doesn't
round it up. Does anyone know how to do this?
|