Hi,
I am trying to have excel come up with a minimum price if my the multiplier for this cell is less than a certain amount. The minimum charge should be $20.
Here is the formula I have for this cell which currently = 16.50. B2 is "50"
=B2*0.22/15*2+15
So what I want is if this formula results in a number less than 20 I want the cell to show 20.
Bookmarks