Thread: rounding to 25 cent incriments
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default rounding to 25 cent incriments
Hi,

=ROUND(A1*4,0)/4

or

= ROUND(A1/25,2)*25

HTH,
Bernd

Reply With QuoteReply With Quote