Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I already have a formula in a cell that is formatted to a percentage with no
decimal places. The problem I have is that excel decides to either round up or down the result if it ends with .5 How can I ensure that the final result is rounded up to the next full number if if currently ends with .5 For example 7.1 + 8.6 = 16 if no decimal points. But 7.1 + 8.4 can either = 15 or 16 (no decimal places). How can I ensure that this always shows 16 as 15.5 should be rounded up to 16 not down. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unwanted rounding of large number | Excel Worksheet Functions | |||
Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
Percentage rounding error in charts | Excel Discussion (Misc queries) | |||
Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) |