Invoice Formula
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. |
All times are GMT +1. The time now is 03:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com