# If statement for different values multiply

#### rentonhighlands

##### Board Regular
Please help me write a IF statement to do this

If COL X has 10 then multiply by \$14.19, if COL X has 20 then multiply by \$18.49
I have 8 to sting together. Can a IF statement string 8 different calculations together?

### Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

#### gaz_chops

##### Well-known Member
Better to use a lookup, something like

=X2*LOOKUP(X2,{10,20,30,40,50},{14.19,18.49,20,30,40})

#### rentonhighlands

##### Board Regular
I was unclear with my last request for help
I have this formula =LOOKUP(K4,{10,20,30,40,50,100,150,1000,2000},{14.19,18.49,28.38,38.27,63.64,102.52,255.15,255.15})
what I need this formula to do is when in col K4 it finds "10" then populate \$14.19, if we find 20 then populate \$18.49, if we find 50 then populate \$28.38, if we find 150 then populate \$63.64.

What is happening now is when it finds "50" it is populating \$63.64.

Replies
1
Views
38
Replies
5
Views
89
Replies
9
Views
106
Replies
4
Views
61
Replies
2
Views
25