Thread: rounding decimals to nearest quarter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default rounding decimals to nearest quarter
=CEILING(A1,0.25)


"ajeuck" wrote:

How do I round a dollar amount to the nearest .25

i.e. 11.17 to 11.25, 11.37 to 11.50, 11.67 to 11.75 and so on.....
Reply With QuoteReply With Quote