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?

✔ 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.

Don't know what you did wrong, but my calculation are: $9,444,894.84

Someplace your rounding or truncating your sum.

MIKE

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.

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.

Alwayspop back and let us know the outcome - thanks

the formula is "=D38*D25"

Where does the data from D38 & D25 come from? Is it entered manually or are they the result of a formula?

MIKE

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.

Just as a reference, I can duplicate your situation if I do 11660364 * 0.8134328

How are cell D25 & D38 formatted?

MIKE

d38 is a result of "d11/d23" (218/268) and d38 is a result of "=D30-D36" ($14,417,420 - $2,757,056)

See Response #6 for the explanation. 218/268 = 0.813432836

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

Actually, we would like for it to be accurate since an annual fee is based on that total. Any suggestions?

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 to

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

MIKE

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.

Yep, Excel is spot on.

Alwayspop back and let us know the outcome - thanks

Ask Your Question

Weekly Poll

Do you agree with Google's decision to shut down Google+?

Discuss in The Lounge

Poll History