Rounding number to the nearest quarter

G

Guest

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
 
B

Bob Phillips

=CEILING(A1,0.25)

--

HTH

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding to the nearest quarter 2
Alternate Rounding Up & Down of .50 in a column 5
rounding to the nearest quarter 3
rounding up to the nearest 1000 1
Rounding Time to Nearest 5 Minutes 1
Rounding in the Same Cell 2
formula/version 2007 2
Rounding a sum to the quarter hour. 3

Top