The minimum price from the 5 cells is obtained with MIN(I2,K2,M2,O2,Q2)
If you want the larger of this and D2 then: =MAX(MIN(I2,K2,M2,O2,Q2),D2)
Have I read your question correctly?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
wrote in message
...
(D2) holds the customer's target price, (F2) holds the price at which
the company will sell to the customer, the formula in (F2) is based on
the lowest price from 5 different vendors: (I2, K2, M2, O2, Q2), after
this calculation, if (D2) is higher than (F2) then I want (F2) to
match (D2). How would I do this? Thank you so much.