# 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

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,923That'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.MIKEhttp://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

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*D25My 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.

Report •

#7
February 28, 2013 at 15:54:43
 Just as a reference, I can duplicate your situation if I do11660364 * 0.8134328How are cell D25 & D38 formatted?MIKEhttp://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

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 totalSince you have not yet explained what it is your doing, nor what your results should be, it's kind of difficult tooffer any solution.Explain, in detail, what it is your doing and what results your looking for.MIKEhttp://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)MIKEhttp://www.skeptic.com/

Report •

#13
February 28, 2013 at 17:02:23