Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
(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 | |
|
|
![]() |
||||
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 |