1. Problem:
What I need to determine is whether the price difference of the BLIST PACK is 0.15 ($0.15) or more than the unit price of the items for the same Generic Code Num Seq in Colum B that are BOTTLES (Column I). If BLIST PACK is more than 0.15 ($0.15) than the lowest price BOTTLE for the Generic Code Num Seq Num then I need to buy it in BOTTLES.
About the data
Data example and desired results attached
Data exists in Columns A-O
Colum B is an industry number , Generic Code Num Seq Num ,that is specific drug and strength in column C regardless of the quantity the package.
Colum I is Package Desc. BLIST PACK or BOTTLE
Column O is Unit Price
Example:
DIGOXIN 100 .125 and DIGOXIN 1000 .125 have the same Generic Code Num Seq Num (in this case 18). The strength is 0.125. The numbers 100 and 1000 are the number of tablets in the package.
NOTE: Some but not all of the products come in BOTTLE and BLIST PACK (Column I).
Parameters:
1.) If the unit price BLIST PACK is 0.15 ($0.15) or more that the lowest unit price of the items for the same Generic Code Num Seq in Colum B that are BOTTLES (Column I) then the lowest price BOTTLE for that same Generic Code Num Seq. row should copy across. I would have to buy the lowest price BOTTLE unit cost.
2.) If the BLIST PACK unit price is NOT more than 0.15 ($0.15) of the lowest unit price of the items for the same Generic Code Num Seq in Colum B that are BOTTLES (Column I) then the lowest BLIST PACK for that same Generic Code Num Seq. row should copy across. In this case I can by the BLIST PACK
3.) If there is not a BLIST PACK then the lowest unit price for the Generic Code Num Seq. row should copy across.
Bookmarks