J JOHN Feb 27, 2009 #1 How do I round a dollar amount to the nearest quarter?.... I only find formulas in help to round to the nearest decimal place.
How do I round a dollar amount to the nearest quarter?.... I only find formulas in help to round to the nearest decimal place.
J JOHN Feb 27, 2009 #3 Thank you very much, it worked perfectly. Elkar said: Try this: =ROUND(A1/0.25,0)*0.25 HTH Elkar Click to expand...
Thank you very much, it worked perfectly. Elkar said: Try this: =ROUND(A1/0.25,0)*0.25 HTH Elkar Click to expand...
R Ron Rosenfeld Mar 1, 2009 #4 How do I round a dollar amount to the nearest quarter?.... I only find formulas in help to round to the nearest decimal place. Click to expand... =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
How do I round a dollar amount to the nearest quarter?.... I only find formulas in help to round to the nearest decimal place. Click to expand... =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
