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

Hi

This should work I guess

if A1 contains your value, den put this in any cell to get the rounded
value.

=IF(MOD(A1,0.25) = 1/8, CEILING(A1,0.25), FLOOR(A1,0.25))


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=548291

Reply With QuoteReply With Quote