I have some data where I need to calculate the "best deal". I have the basic math worked out, I just need to find a way to implement it into an excel sheet or macro. Here is how my data is structured: minimum buy quantity, rate 1, rate 2, rate 3, company, order quantity ...
item 1 1000, 5, 4...