Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
The difference you're seeing is due to the way Excel calculates a
number compared to the way it displays a number. If you divide 100 / 3 on a calculator, you get 33.3333333 with infinitely recurring threes. If Excel performs this calculation in a cell formatted for currency, the answer will display as $33.33. The recurring threes are still there, but they are not displayed. Check out the ROUND() function, which allows you to control the number of decimal places. In this example, =ROUND(100/3,2) the answer is 33.33 with no further recurring threes. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Percentage rounding error in charts | Excel Discussion (Misc queries) | |||
How do I get my formula to stop rounding up | Excel Worksheet Functions | |||
Rounding numbers to the nearest thousand | 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) |