Rounding dollar amount to the nearest quarter

[John Capela]

I need a formula to round dollar amounts down to the nearest quarter (.25).
for example
1254.78 = 1254.75
154.85 = 154.75
112.27 = 112.25
645.58 = 654.50

 

[Anon]

I need a formula to round dollar amounts down to the nearest quarter (.25).
for example
1254.78 = 1254.75
154.85 = 154.75
112.27 = 112.25
645.58 = 654.50

For a number in A1, you can use
=ROUND(A1*4,0)/4

Alternatively, if you enable the analysis toolpak you can use
=MROUND(A1, 0.25)