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
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 is 25.71.
So why don't they equal each other mathematically????
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 is 25.71.
So why don't they equal each other mathematically????