Rounding to the nearest 1/4 dollar

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Is there a formula that will enable me to get the result
of rounding to the nearest quarter dollar? Example: $1.71
would be returned as $1.75 or $1.60 would be returned as
$1.50.
 
One way:

=ROUND(A1*4,0)/4

or, if you have the analysis toolpack add-in (Tools/Add-ins...)
installed,

=MROUND(A1, 0.25)
 
Assuming that the dollar values are in column A and also assuming that there
are no more than 2 decimal places, here is an answer that might work.

=INT(A1) + ROUND(RIGHT(A1*100,2)/25,0)*0.25

Let me know if this does it for you.
 
Back
Top