Solved results differ from excel and manual calculator

February 28, 2013 at 12:29:08
Specs: Windows XP
I have a formula to calculate a percentage (.81) in one cell times a dollar amount ($11,660,364) in the other. Excel calculates it as $9,484,923, but on the calculator, I get $9,444,895. Help, please!

How can I correct it?


See More: results differ from excel and manual calculator

Report •


✔ Best Answer
February 28, 2013 at 17:02:23
If you want it to be accurate, there is nothing to suggest because the answer Excel gave is absolutely accurate.

218/268 = 0.813432836

$11,660,364/0.813432836 = $9,484,923

That's exactly what Excel returned...you can't get much more accurate than that.

The inaccuracy existed when you entered .81 in the calculator. If 218 is accurate and 268 is accurate, then 0.813432836 is accurate and is the number you should be using.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.



#1
February 28, 2013 at 12:36:01
Don't know what you did wrong, but my calculation are:

$9,444,894.84

Someplace your rounding or truncating your sum.

MIKE

http://www.skeptic.com/


Report •

#2
February 28, 2013 at 13:05:42
I often wonder why posters to Help forums such as this one write things like "I have a formula ...." but don't post the formula for us to see.

It happens very often and I never understand how they expect us to help them when we don't have all of the information we need.

"How can I correct it?"

Correct what?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#3
February 28, 2013 at 13:20:46
I have a job to see how rounding or truncating should create such a difference in the third digit given the number of places showing. As said, give us the formula.

Always pop back and let us know the outcome - thanks


Report •

Related Solutions

#4
February 28, 2013 at 15:35:29
the formula is "=D38*D25"

Report •

#5
February 28, 2013 at 15:45:57
Where does the data from D38 & D25 come from?

Is it entered manually or are they the result of a formula?

MIKE

http://www.skeptic.com/


Report •

#6
February 28, 2013 at 15:48:24
If I put .81 in D38 and $11,660,364 in D25 (or vice versa) I get $9,444,894.84 when using =D38*D25

My guess is that your .81 isn't really .81.

In order to get $9,484,923 Excel's Solver utility says the multiplier must be .81343284.

If I display that cell with only 2 decimal places, it will look like .81 but if it is the result of a formula, Excel will use the exact value, not the displayed value.

How you "correct it" depends on how accurate you want the final result to be.


Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#7
February 28, 2013 at 15:54:43
Just as a reference, I can duplicate your situation if I do

11660364 * 0.8134328

How are cell D25 & D38 formatted?

MIKE

http://www.skeptic.com/


Report •

#8
February 28, 2013 at 15:58:25
d38 is a result of "d11/d23" (218/268) and d38 is a result of "=D30-D36" ($14,417,420 - $2,757,056)

Report •

#9
February 28, 2013 at 16:03:40
See Response #6 for the explanation.

218/268 = 0.813432836


Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#10
February 28, 2013 at 16:41:09
Actually, we would like for it to be accurate since an annual fee is based on that total. Any suggestions?

Report •

#11
February 28, 2013 at 16:51:26
we would like for it to be accurate since an annual fee is based on that total

Since you have not yet explained what it is your doing,
nor what your results should be, it's kind of difficult to
offer any solution.

Explain, in detail, what it is your doing and what results your looking for.

MIKE

http://www.skeptic.com/


Report •

#12
February 28, 2013 at 16:56:38
Just as a guess, something like this in cell D38:

=ROUND((D11/D23),2)

MIKE

http://www.skeptic.com/


Report •

#13
February 28, 2013 at 17:02:23
✔ Best Answer
If you want it to be accurate, there is nothing to suggest because the answer Excel gave is absolutely accurate.

218/268 = 0.813432836

$11,660,364/0.813432836 = $9,484,923

That's exactly what Excel returned...you can't get much more accurate than that.

The inaccuracy existed when you entered .81 in the calculator. If 218 is accurate and 268 is accurate, then 0.813432836 is accurate and is the number you should be using.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#14
February 28, 2013 at 17:34:28
Yep, Excel is spot on.

Always pop back and let us know the outcome - thanks


Report •


Ask Question