J
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.
formulas in help to round to the nearest decimal place.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Elkar
Try this:
=ROUND(A1/0.25,0)*0.25
HTH
Elkar
=ROUND(A1/0.25,0)*0.25
HTH
Elkar
J
JOHN
Thank you very much, it worked perfectly.
Elkar said:Try this:
=ROUND(A1/0.25,0)*0.25
HTH
Elkar
R
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