ROUNDING NUMBERS
 

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

ROUNDING NUMBERS
 

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.

ROUNDING NUMBERS
 

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.

ROUNDING NUMBERS
 

On Fri, 27 Feb 2009 09:17:01 -0800, 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.

=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