Formula to calculate loss
Well the issue is that in the spreadsheet, there may be a mfg # that is used
by several manufacturers or a description that is used by several manufacturers. What I need to do is say, there are 14,000 records... i need to calculate the loss on based on the mfg #, but the mfg # must match the same manufacturer and description. There may be a total 0f 15 row of Data that have the same mfg #, manufacturer and description... 5 rows purchases at $0.01 as the unit price, 5 rows show purchases at $0.05 as the unit prices and 5 rows show purchases at $0.08 as the unit price.... what is the difference if we would have purchased all 15 at $0.01 as opposed to what we actually purchased.... I hope I clarified... -- Thank you very much for your help!!! I really appreciate it :o). "Dave F" wrote: Well, there's probably a way. When you say you want to test if the manufacturer, description and mfg# match, what do you mean? That they equal each other? That they match another criteria? Dave -- Brevity is the soul of wit. "Dee" wrote: I have a worksheet where I have the following columns: INVOICENUMBER, TYPE, INVOICEDATE, BILL-TO, COSTCENTER, PRACTICENAME, ADDRESS, CITY, STATE, ZIP, MFGNO, MANUFACTURER, DESCRIPTION, ITEMNO, UNIT, QTYSHIP, UNITPRICE, AMOUNT. I have tried several different approaches to manipulate this data. Now I want to see if there is a way to say... If the manufacturer, description, & mfg # match, take the lowest unit price and multiply that by the sum of the quanitity then subtract that from what the actual total of the amount spent (sum of amount) and the result would be the loss of $$ due to purchasing at those higher prices. How can I do this... even if it is not all in one formula, there has to be a way. -- Thank you very much for your help!!! I really appreciate it :o). |
All times are GMT +1. The time now is 06:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com