Excel - simple calculation giving wrong answer

R

RisseN

Well-Known Member
Joined
Sep 21, 2005
Messages
486
Reaction score
0
Location
JHB
Hey all,

I've got a weird excel problem. Hopefully someone is willing to have a quick look. I've attached a picture.

The calculation is extremely simple yet for some reason excel is giving the incorrect answer. Version 2007.

The total is calculated by multiplying 11.37 * 126 which should equal 1432.62.

In the first example I have just manually typed in the values 11.37 and 126. The total below is then calculated correctly.
However in the second example 126 is calculated by dividing 1000 by 7.91. In this example, an incorrect total is given.

Both totals should be the same. It's the same calculation.

Any ideas what is going on? This appears to be an excel bug.

Is anyone able to reproduce the error?

ProblemPic.PNG
 
RisseN said:
However in the second example 126 is calculated by dividing 1000 by 7.91. In this example, an incorrect total is given.



Any ideas what is going on? This appears to be an excel bug.

Is anyone able to reproduce the error?

View attachment 195048
Click to expand...

If you show more decimal points, you'll notice that 1000 / 7.91 =126.422......

Then its not that same as 126 * 11.37
 
What I can see is that 1000/7.91 = 126.4222503160556 and not just 126. If I multiply 126.4222503160556 by 11.37 I also get to the answer of 1437.42 (1437.420986093552)

Format cell E4 to show more decimal places.
 
Last edited:
As the others have said, 1000 / 7.91 != 126.000.

If you want the correct calculation, it should be 1000 / 7.93650793650794.
 
Last edited:
Thanks everyone. That was quick.

Im going to crawl back into my hole with embarrassment.

Thanks again.
 
Change your formula in E4 to =ROUND(D3/D4,0)
 
I'm way too slow. I was going to ask whether the OP is using it on a Pentium.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X