Need a simple "IF" formula please

[Dee0007]

Hello,

I would like to create if formula with 3 different solutions.

For example in my A1 cell I want three option : a b or c

I want the formula to go something like this, if a1=a than a2*16 , if a1=b than a2*18, , if a1=c than a2*20

How do I put this in a excel formula ??

Thank you in advance

 

[S.H.A.D.O.]

Does this work for you?

=IF(A1="","",IF(A1="a",A2*16,IF(A1="b",A2*18,IF(A1="c",A2*20))))

I hope this helps!

 

[Dee0007]

Does this work for you?

=IF(A1="","",IF(A1="a",A2*16,IF(A1="b",A2*18,IF(A1="c",A2*20))))

I hope this helps!

Thank you , much appreciate it !

 

[S.H.A.D.O.]

You're welcome and thanks for the feedback.

 

[Dee0007]

Hi again

one more question

if i want to make a similar formula but instead of a ,b c i would like to replace a with "= or less than 100" replace b with "101-150" c with 151=200" and make additional " 200 or more

 

[S.H.A.D.O.]

Do you mean something like this...

=IF(A1="","",IF(A1<=100,A2*16,IF(A1<=150,A2*18,IF(A1<=200,A2*20,IF(A1>200,"More than 200.")))))

I hope this helps!

 

[Dee0007]

Hi,

This kind of helped but not really:

this formula actually works which is essentially the same but the the greater and less than signs are reversed:

c6=10

=IF(C6="","",IF(C6<=100,B6*10,IF(C6>=101,B6*20,IF(C6>=151,B6*30))))

BUT, what doesn't work in this formula which i cant figure out why is the last one " if greater than 150, and it doesn't matter which way i put the sign in" < or >" it will always give me the answer 200 which is "C6>=101,B6*20"


Why is that?

 

[S.H.A.D.O.]

=IF(C6="","",IF(C6<=100,B6*10,IF(C6>=101,B6*20,IF(C6>=151,B6*30))))

I am afraid I don't quite understand why you couldn't adapt the formula I gave you?
Where did the 16 and 18 go and wher did the 30 come from, they were not in your original post or criteria?