• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

FIFO Excel

P

Pushkin

New Member
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
 

Attachments

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?
 
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
 
You must log in or register to reply here.
Back
Top