Good morning everyone, hello Saqib Husain, Syed
I am refering to the discusion https://www.experts-exchange.com/questions/29084963/Excel-formula-for-calculating-the-Cost-Value-on-FIFO-basis.html
The formula gives a false calculation when i changed the price.
The bying price of AAA ligne 3 E:3 is 501,00. If i put 501,93, the formula calculate the same cost which is 12.525,00 as for 501,00 in I:9 but the correct result is 25*501,93 = 12.548,25 not 12.525,00. Thank you
Please see the file attached.
Thank you for reading