S
stevelarsen
I am looking for a way to create a formula/macro to do the following:
I have 8 speeds of laptops in column E
(650,700,800,850,900,1000,1130,1200) and 4 conditions in column T
(A,B,C,D). Based upon those two values I then need to assign a cost to
column U.
For example, if e60=650 and t60=b then 97.50
Below is the full matrix of pricing I need to have the formula
calculate based upon the two cells values.
Mhz Condition A Condition B Condition C Condition D
650 $162.50 $97.50 $78.00 $50.00
700 $175.00 $105.00 $84.00 $50.00
800 $200.00 $120.00 $96.00 $50.00
850 $212.50 $127.50 $102.00 $50.00
900 $225.00 $135.00 $108.00 $50.00
1000 $250.00 $150.00 $120.00 $50.00
1113 $278.25 $166.95 $133.56 $50.00
1200 $300.00 $180.00 $144.00 $50.00
I have 8 speeds of laptops in column E
(650,700,800,850,900,1000,1130,1200) and 4 conditions in column T
(A,B,C,D). Based upon those two values I then need to assign a cost to
column U.
For example, if e60=650 and t60=b then 97.50
Below is the full matrix of pricing I need to have the formula
calculate based upon the two cells values.
Mhz Condition A Condition B Condition C Condition D
650 $162.50 $97.50 $78.00 $50.00
700 $175.00 $105.00 $84.00 $50.00
800 $200.00 $120.00 $96.00 $50.00
850 $212.50 $127.50 $102.00 $50.00
900 $225.00 $135.00 $108.00 $50.00
1000 $250.00 $150.00 $120.00 $50.00
1113 $278.25 $166.95 $133.56 $50.00
1200 $300.00 $180.00 $144.00 $50.00