I would like to set up my excel sheet to auto calculate. The problem I have
multiple factors to column B
B C D
1 Product code A 100 ?
2 Product code B 50 ?
3 Product code C 25 ?

I want to be able to have a formula in cell D that will look to see if it's
any of the product codes something like if B1=product code A then (c1*20), or
if B1=product code b then (c1*50)

Thanks in advanced!