Hi Potaroo,

=ROUNDUP(A1*4,0)/4
=ROUND(A1*4,0)/4
=ROUNDDOWN(A1*4,0)/4
will round the value in A1 to the nearest higher quarter, nearest quarter, or nearest lower, quarter, respectively.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Potaroo" wrote in message ...
I'm after a formula that will give me the closest to a 0.25 incremental
ending.
That is if the sum ends up being 4.29, I need it to return a 4.25
If it ends up being 2.8 I need it ot return a 2.75.
If it ends up being 2.89 I need it ot return a 3.
Is there such a method?
TIA to all you Gurus.
Pete