| 0 |
Subject: Excel Rounding Problem
Posted by: enfuego
- [325432212] Wed, Jun 30, 2004, 14:11
How do you keep formulas from re-calculating and re-rounding?
For example:
Result of row 1 figures = 525.84
Result of row 2 figures = 6.20
I want the sum of those two results to read 532.04 but my sum is reading 532.05 because it's re-rounding that total up due the figures being 525.844 and 6.204.
Any help would be greatly appreciated.
|
| 1 | Guru
ID: 330592710
Wed, Jun 30, 2004, 14:35
|
Use the ROUND function.
For example, ROUND(525.844,2)=525.84
|
| 2 | MadDOG
ID: 523010
Wed, Jun 30, 2004, 14:59
|
Isn't 532.05 more accurate then 532.04?
I already know the answer but am just wondering why you prefer 532.04?
|
| 3 | enfuego
ID: 325432212
Wed, Jun 30, 2004, 14:59
|
thanks!
|
| 4 | enfuego
ID: 325432212
Wed, Jun 30, 2004, 15:12
|
It's because we rounded everything to two decimal places when doing it on paper and we didn't want to change it now.
|
| 5 | MadDOG
ID: 523010
Wed, Jun 30, 2004, 15:18
|
You must mean you "truncated" everything to 2 decimal places. Which means you just cut off everything after the 2 decimal places.
If you actually were rounding, then 532.05 is what it should be.
|
| 6 | MadDOG
ID: 523010
Wed, Jun 30, 2004, 15:21
|
BTW, Excel has a TRUNC function which will do exactly that. Syntax is exactly like ROUND.
I guess what you are talking about is that you rounded the numbers before they were added together.
|
| 7 | Guru
ID: 330592710
Wed, Jun 30, 2004, 15:25
|
MadDOG, we don't have enough information to know if 532.05 is a better answer or not.
Suppose the question is that someone made purchases at two different stores. The spreadsheet is to calculate the total sale at each store, including sales tax, and then total the amount spent at both stores.
In this case, it would be proper to round each store's final amount, before adding the two numbers together. The fractional cents (due to sales tax) should not be carried forward. The total amount spent is the sum of the two rounded figures, or 532.04. The answer 532.05 would be incorrect.
So there.
|
| 8 | MadDOG
ID: 523010
Wed, Jun 30, 2004, 15:33
|
Hey the TRUNC function is part of Excel for a reason. I wasn't insinuating that there wasn't any situations where you wanted to TRUNC or ROUND numbers before they are added together.
I was just saying the most accurate number if your just adding the two numbers together is 532.05.
|
| 10 | Sludge
ID: 523482015
Wed, Jun 30, 2004, 15:52
|
This is starting to sound like the beginning to the movie Office Space.
|
| 11 | RecycledSpinalFluid
Dude
ID: 204401122
Wed, Jun 30, 2004, 16:19
|
Office Space Wars
|
| 12 | MadDOG
ID: 523010
Wed, Jun 30, 2004, 16:26
|
OK, this thread has definitely been sidetracked. Not even close to the original topic. :) LOL
|
| 13 | J
Leader
ID: 49346417
Thu, Jul 01, 2004, 09:34
|
LMFAO RSF!!!!!! That was the funniest thing I've seen in months!!!!
|
|
|
Post a reply to this message: (But first, how about checking out this sponsor?)
|