Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Past Special Concatenated formula | Excel Discussion (Misc queries) | |||
ANY SPECIAL ARRAY OR OTHER FORMULA | Excel Discussion (Misc queries) | |||
Special Lookup Formula | Excel Discussion (Misc queries) | |||
Paste Special Formula | Excel Worksheet Functions | |||
special sum formula | Excel Worksheet Functions |