ROUNDING NUMBERS

[JOHN]

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

 

[Elkar]

Try this:

=ROUND(A1/0.25,0)*0.25

HTH
Elkar

 

[JOHN]

Thank you very much, it worked perfectly.

Try this:

=ROUND(A1/0.25,0)*0.25

HTH
Elkar

 

[Ron Rosenfeld]

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

=ROUND(A1/0.25,0)*0.25

or

=MROUND(A1,0.25)

If this gives a #NAME error in a version prior to Excel 2007, see HELP for this
function for instructions on installing the Analysis tool pak.
--ron