FIFO Excel

[Pushkin]

Hi can anyone help me with fifo excel formula

i have uploaded a sample file
i want to calculate remaining amount and opportunity cost based on fifo method if any one can help regarding this would be glad.

Thanks

 

[Hui]

Pushkin

Firstly, Welcome to teh chandoo.org Forums

Not really sure what the question is?

But is H2: =SUM(B2:B3)-SUM(E2:E6)
what your after?

 

[Pushkin]

Hi
Thanks

basically there are inward entry and outward entry
i want to calculate remaining amount the outward entries must subtract itself from the first entry and then on that basis i want to calculate opportunity cost.

Regards

 

[Hui]

Can you manually enter what you expect as a result?