Thread: Rounding to the nearest quarter
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Rounding to the nearest quarter
=mround(A1,0.25)
--
David Biddulph

"pdberger" wrote in message
...
If I have the results of a calculation in cell A1, how do I round that to
the
nearest quarter?
Thanks in advance.


Reply With QuoteReply With Quote