New to Formuals

T

Tanya

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!
 
T

T. Valko

How many products are there? If there's only a few you can use a formula
like this:

=C1*IF(B1="A",20,IF(B1="B",50,IF(B1="C",75,0)))

If you have more than a few then you should create a 2 column table like
this:

...........J..........K
1.......A.........20
2.......B.........50
3.......C.........75
4.......D.........65
etc

Then use a formula like this:

=C1*VLOOKUP(B1,J$1:K$4,2,0)

Biff
 
M

Max

First, set up a lookup table in say cols G & H,
eg in G1:H1 down you'd have:
Product code A 20
Product code B 50
Product code C 80
etc

Then you could use in D1:
=C1*VLOOKUP(B1,G:H,2,0)
and copy D1 down
 
Top