calculating a special formula

[vjohns158]

(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.

 

[Bernard Liengme]

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