calculating a special formula
(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. |
calculating a special formula
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. |
All times are GMT +1. The time now is 12:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com