| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what are the rules for a valid sheet name in excel | Excel Discussion (Misc queries) | |||
| Copying Rules in Excel | Excel Discussion (Misc queries) | |||
| how do I set up a validation rules with two data rules | Excel Worksheet Functions | |||
| How can I alter the rounding rules? | Excel Worksheet Functions | |||
| I need 5 conditional formatting rules-excel only allows 3 | Excel Discussion (Misc queries) | |||
Threaded Mode
