Rounding number to the nearest quarter

D

Dajana

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 a number up to a certain ending digit 6
Alternate Rounding Up & Down of .50 in a column 5
Rounding Time to Nearest 5 Minutes 1
rounding up to the nearest 1000 1
Rounding to the nearest quarter 1
Rounding in the Same Cell 2
formula/version 2007 2
Round Function 5

Top