Round up to next .5

[LKP]

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?

 

[Pete_UK]

Try this:

=CEILING(A1,0.5)

Hope this helps.

Pete

 

[Glenn]

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?

=CEILING(A1,0.5)

 

[LKP]

Never mind. Found it in another post. Thanks!

 

[LKP]

Thanks guys!

Try this:

=CEILING(A1,0.5)

Hope this helps.

Pete

 

[Pete_UK]

You're welcome.

Pete