See the attached image files of an excel workbook. The second file shows the formulas in each cell and the first shows the results in each cell. Basically my question is, if I change cell C3 to anything but 1 (so that it matches B3), there will always be variance in cell E6. Why?

Or to put it another way:

Lets say

Month 1 Month 2 Total Employee A Salary 9 9 sum of the left two values (18) Employee B Salary 1 2 sum of the left two values (3) % of above that is Employee A Salary 90% or 9/(9+1) 81.82% or 9/(9+2) 86% or 18/(18+3) Total Benefits (unrelated static number) 10 20 sum of left two values (30) Employee A Allocated Benefits 9.00 or 90%*10 16.36 or 81.82% * 20 25.71 or 86% * 30

So if we go to the last row and add up Employee A + B individually we get 9 + 16.36 =25.36.

But if we look at the total column only on the last row, the result is25.71.

So why don't they equal each other mathematically????

## Bookmarks