Help Rounding Up

[skate1991]

Hi,

I was just wondering if anyone could help me on the below problem.

I need to round the number to the nearest 0.25 and to always round up. So if its 1.76 it would round to 2 etc.

Thanks

[Søren Larsen]

Try this:

Please Login or Register  to view this content.

[Pete_UK]

Try this:

=CEILING(A1,0.25)

Hope this helps.

Pete

[dilipandey]

HI Skate,

Try using:-

Please Login or Register  to view this content.

regards,
DILIPandey

<click on below 'star' if this helps>

[skate1991]

Hi

Thats perfect./

Thanks for you help

[martindwilson]

did anyone mention

Please Login or Register  to view this content.

oh yes loads