I am struggling to find a proper explanation why the two methods that I use for finding the difference in EXCEL are giving me two slightly different numbers.
The idea behind the task is that we have a post office and we have an X items that are coming in and Y items that are going out. The data is for the last two years and all of the items are categorized for each month of the year.
I was thinking that the difference between the average in "IN" and the average in "Out" must give the difference between the total "Old" and total "New". However, the results are by 0.09 off, which frankly is quite a big number if we take into consideration that instead of a post office we are working with some sort of a financial institutions.
I would be extremely grateful if you can share your opinion in this regard. Thank you in advance!
Yours sincerely, MathBeginner