Thread: How do I modify rounding rules in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
  
Posts: 1,236
Default How do I modify rounding rules in Excel?
=IF(MOD(A1, 1)=0.5, INT(A1) + MOD(INT(A1), 2), ROUND(A1, 0))

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"merritaf" wrote in message
...
I would like to have excel use a modified rounding rule, where when a
calculation anwers has a '.5' value the odd numbers rounded up to next
whole
number and even numbers are rounded down.....(example 13.5 would be
rounded
up to 14 and 4.5 would be rounded down to 4). I need to have ecel do a
computation and then apply this rounding rule.


Reply With QuoteReply With Quote