View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
[email protected] vjohns158@gmail.com is offline
external usenet poster
 
Posts: 6
Default 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.