View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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