View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
merritaf merritaf is offline
external usenet poster
 
Posts: 3
Default How do I modify rounding rules in Excel?

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.