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