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
|