| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| invoice toolbar for invoice calcuation and assign number | Excel Discussion (Misc queries) | |||
| How do I assign an invoice number using the invoice toolbar? | Excel Worksheet Functions | |||
| missing invoice toolbar when save customised invoice | New Users to Excel | |||
| Invoice templet Excel97 to 2003 invoice toolbar missing | Excel Discussion (Misc queries) | |||
| How do I change the invoice number assigned in Invoice template... | Excel Discussion (Misc queries) | |||
Linear Mode
