Rounding dollar amount to the nearest quarter

  • Thread starter Thread starter John Capela
  • Start date Start date
J

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
 
John Capela said:
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
Click to expand...

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)
 
Back
Top