Rounding to the nearest 1/4 dollar

[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.

 

[J.E. McGimpsey]

One way:

=ROUND(A1*4,0)/4

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

=MROUND(A1, 0.25)

 

[news stuff]

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.