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