Hi!
I have a simple calc that looks at 12 months and then has a total column.
Row 1: employees A salary by month (static)
Row 2: employees B salary by month (static)
Row 3: % that is employee A of the total of the first two rows (% that is employee A of total) (calculated)
Row 4: Total benefits (static)
Row 5: How much of total benefits should go to employee A based on row 3 (employee A % of total salary) (calculated)
But the problem is that the sum of Jan - Dec for the last row does not equal the same as if I do the formula on the total year.
See attached file.
Is this a math problem? An excel problem? Shouldn't they exactly match?
Bookmarks