Thread: Rounding number to the nearest quarter

I am using Excel 2000 and I need to round up number to the nearest quarter.
For example if I enter 1.15 I want excel to round it up to 1.25, if entered
1.37 to round it up to 1.50 and so on. Is there a way to do this.

Thanks

=CEILING(A1,0.25)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dajana" <Dajana@discussions.microsoft.com> wrote in message
news:427F2B6D-11BE-47ED-A5BC-7E7F5DAA4A22@microsoft.com...
> I am using Excel 2000 and I need to round up number to the nearest
quarter.
> For example if I enter 1.15 I want excel to round it up to 1.25, if
entered
> 1.37 to round it up to 1.50 and so on. Is there a way to do this.
>
> Thanks