Rounding numbers

[DandD]

Is there a way to round numbers to the nearest quarter.
In my sheet I have a cell (A1)that is the sum of a group of other cells(B1:B10).
I want A1 to only round to the .25, .5, .75 or 0. Can someone please help?
I dont want the cells to be in a fraction format.

[Andrew-R]

=int(a1*4)/4

[DonkeyOte]

Given your use of XL2010 you can utilise MROUND

=MROUND(A1,0.25)

Prior to Excel 2007 the use of MROUND required activation of the Analysis ToolPak Add-In

[kmlloyd]

To round up to the nearest .25:
=ceiling(A1,.25)

To round down to the nearest .25:
=floor(A1,.25)

[DandD]

Thank you. This is my new favorite place to be. I always loved excel, but now that I can get answers to my little questions Life just got a whole lot better.
Jess
New problem.
The cells which is all of column B is already using a function. Let me explain in my own laymans terms. For example....I want cell A1 to equal the sum of B1:B12. How then if cell A1 already has a function in it =SUM(B1:B12). How then do I get cell A1 to perform the required function and still round it to the quarter?

[Whizbang]

In place of "A1" in any of the solutions given, use your formula.

=int(SUM(B1:B12)*4)/4

=MROUND(SUM(B1:B12),0.25)

=ceiling(SUM(B1:B12),.25)

[DandD]

Thanks so much.