My Data Table looks like this:

Qty Buyer Seller ChargedSide
2 BOX980 BOX226 Buyer
30 BOX226 BOX917 Seller


I am trying to create a new table like this:

Charge Credit
BOX980 Formula (2 x $50) Formula (0 x $25)
BOX917 Formula (30 x 50) Formula (0 x $25)
BOX226 Formula (0 x 50) Formula (2x25 + 30x25)

So for each customer in ColA, look at the data table, determine whether the
charder side is the buyer or seller, and then apply the formula to determine
the Charge or Credit.

Thank you in advance.