On Fri, 20 Jan 2006 17:59:01 -0800, Dandub
wrote:

Hi, I have a stubburn problem with percentages!! Here are the values
A1 = 179814
B1 = 238920
C1 = sum(A1+B1) = Excel returns 418734
D1 = (A1/C1) = Excel returns 42,94%
E1 = (B1/C1) = Excel returns 57,06%
Now the problem is, when I do the verification, %*418734, Excel does not
return the correct values.
A2 = 42.94%
B2 = 57.06%
C2 = 418734
D2 = (A2*C2) = Excel returns 179804 and not the original 179814
E2 = (B2*C2) = Excel returns 238930 and not the original 238920

Funny enough, there is a rest of 10 when comparing results (D2 was added 10
and E2 is missing 10 to equal their original values.
Please enlighten me... what am I not grasping here?

Thank you


I presume you entered the 43.94% and the 57.06% manually.

What you are missing is that the values you see in D1 and E1 are NOT the values
that Excel calculated; rather they are the correct values displayed to 2
decimal places.

The values that Excel really returned we

D1: 42.9422974967402%
E1: 57.0577025032598%

If you put those values into A2 and B2, the verification will work.

More simply, you could enter

A2: =D1
B2: =E1



--ron