=CEILING(A1,0.25)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Dajana" wrote in message
...
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
|