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