Displacement formula

[excelas88]

Hello,

I am having trouble trying to find a way to calculate the displacement for two columns.

What formula can I use to calculate the "Qty Displacement" and "Recycled Displaced"

Qty Displacement is basically if "Qty Used" is 10, and "Qty Recycled" is 2, I can only use two "qty recycled" since only two are available. If more are available, the max is what "qty used" states.

Recycled displaced works basically the other way.

Please help me if you guys can. I appreciate it.

Thank you!

Capture1.PNG

[FDibbins]

Please upload a sample of your workbook, not a picture of your data.
Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

[excelas88]

thank you for your response. Here is the attachment. I have over a few hundred thousand rows so I need a formula that I can just drag down.

[FDibbins]

Thanks

D3=MIN(B3,-C3)
E3=IF(D3=B3,"",B3-D3)

Both copied down

[Tony Valko]

Is this a duplicate thread:

http://www.excelforum.com/excel-gene...wo-numbes.html

[excelas88]

Thanks man you're awesome!!

[FDibbins]

Happy to help and thanks for the feedback

I have closed your other thread (for future reference, let us know if you have duplicate threads - and preferably, dont post duplicates)