|You can not attach worksheets to posts in this forum. You can provide a link to a website where the sheet could be found, and if members of this forum choose to, they could go look at it.|
It seems to me that you should only need one formula, along with a table to pull in the minimums.
Since you have not supplied the formula that you are using in C16, I'll have assume that you have a lookup table to populate C16 with a rate based on the port chosen from the drop down.
Again, I'm guessing here, but let's say Sheet2!A1:B26 contains your ports (Column A) and rates (Column B). If that's right, then how about adding a third column (C) with the minimum charges for each port?
In that case, your formula in D16 might be something like:
This formula would check to see if A19*C16 met the minimum listed in Column C. If it didn't, it would return the minimum from the table.
Again, I have to stress that without more specifics as to how you are pulling the data into C16, I'm making multiple assumptions with this suggestion.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.