Hi,
I'm trying to create a pricing calculator that automatically calculates the cost of a service depending on which vendor is used and what service line. Tab one has the calculator and tab two has a list of vendors and their services and different rates for these services. See below example:
TAB ONE: C2&3 is a drop down that pulls from tab two a1:G1 (the vendor names). D2&3 pull from tab two a3:a12 (the turn around time) I want to add a formula on F2 to calculate the cost. Something like If C2 = Lori and D2 = 1 business day then return this formula =(7*amount in E2). Any help is greatly appreciated.
TAB TWO:
I'm trying to create a pricing calculator that automatically calculates the cost of a service depending on which vendor is used and what service line. Tab one has the calculator and tab two has a list of vendors and their services and different rates for these services. See below example:
TAB ONE: C2&3 is a drop down that pulls from tab two a1:G1 (the vendor names). D2&3 pull from tab two a3:a12 (the turn around time) I want to add a formula on F2 to calculate the cost. Something like If C2 = Lori and D2 = 1 business day then return this formula =(7*amount in E2). Any help is greatly appreciated.
SERVICE | VENDOR | TURN AROUND TIME | ESTIMATED QTY | COST | |
T | |||||
C |
TAB TWO: