How do I round a dollar amount to the nearest .25

i.e. 11.17 to 11.25, 11.37 to 11.50, 11.67 to 11.75 and so on.....

=CEILING(A1,0.25)


"ajeuck" wrote:

How do I round a dollar amount to the nearest .25

i.e. 11.17 to 11.25, 11.37 to 11.50, 11.67 to 11.75 and so on.....

Try one of these:

Requires the Analysis ToolPak add-in be installed for Excel versions prior
to Excel 2007:

=MROUND(A1,0.25)

This one will work in any version:

=ROUND(A1/0.25,0)*0.25

--
Biff
Microsoft Excel MVP


"ajeuck" wrote in message
...
How do I round a dollar amount to the nearest .25

i.e. 11.17 to 11.25, 11.37 to 11.50, 11.67 to 11.75 and so on.....

Fabulous!!! Thank you!
Is there a way to set parameters?
i.e if less than .12 round down more than .12 round up?

"Teethless mama" wrote:

=CEILING(A1,0.25)


"ajeuck" wrote:

How do I round a dollar amount to the nearest .25

i.e. 11.17 to 11.25, 11.37 to 11.50, 11.67 to 11.75 and so on.....

=ROUND(A1*4,0)/4

--
__________________________________
HTH

Bob

"ajeuck" wrote in message
...
Fabulous!!! Thank you!
Is there a way to set parameters?
i.e if less than .12 round down more than .12 round up?

"Teethless mama" wrote:

=CEILING(A1,0.25)


"ajeuck" wrote:

How do I round a dollar amount to the nearest .25

i.e. 11.17 to 11.25, 11.37 to 11.50, 11.67 to 11.75 and so on.....