Hi I am trying to make a calculation and have attached a sample workbook for reference. Book1(2).xlsx


In the recovery column, I need a dollar value. If the "6 Month Occurrences for Part Number" is greater than or equal to 3, then the recovery cost is computed Qty*Cost*25% OR $1000 whichever is less. If the "6 month Occurrences for Part Number" is less than 3, then the recovery cost is $0.

I would prefer if the recovery cost for for each Part number is subtotalled.
The recovery costs are calculated separately for each part number.

Any help would be greatly appreciated.