Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Rounded numbers do not add properly.
I saw a post that asked this question and the guy who answered made him look
stupid but I agree with the man. I use Excel to do accounting work. What happens is the numbers add as the original number and not the rounded number. That can lead to some serious miscalculations. Is there a formula that can be used when multiplying or dividing that will round the number to the nearest hundredth and have the column properly add the rounded numbers? The way it is right now, it adds the whole number not the rounded. I think the IRS might have something to say if the pennies start adding up to $100s of dollars in missed tax monies. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
incorrect totals using rounded numbers | Excel Discussion (Misc queries) | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
How can I stop Excel from displaying rounded numbers? Credit car. | Excel Discussion (Misc queries) |