C
carl
My data table looks as so:
Volume Buyer Seller ChargedSide
2 BOX980 BOX226 Buy
30 BOX226 BOX917 Sell
I am trying to find a formula for this table below:
Charge Credit
BOX980 100 (2 x $50) 0 (0 x $25)
BOX917 180 0
BOX226 0 800 (2x25 + 30*25)
So for each ColA, look at the DataTable and depending on if the Buyer or
Seller is on the "ChargedSide" calculate the appropriate Charge or Credit.
Thank you in advance.
Volume Buyer Seller ChargedSide
2 BOX980 BOX226 Buy
30 BOX226 BOX917 Sell
I am trying to find a formula for this table below:
Charge Credit
BOX980 100 (2 x $50) 0 (0 x $25)
BOX917 180 0
BOX226 0 800 (2x25 + 30*25)
So for each ColA, look at the DataTable and depending on if the Buyer or
Seller is on the "ChargedSide" calculate the appropriate Charge or Credit.
Thank you in advance.