Thank you very much, it worked perfectly.

"Elkar" wrote:

Try this:

=ROUND(A1/0.25,0)*0.25

HTH
Elkar


"JOHN" wrote:

How do I round a dollar amount to the nearest quarter?.... I only find
formulas in help to round to the nearest decimal place.