If then statement - help needed

[melmartin]

Hi there! I am wondering if anyone can help me figure out an if then statement I am working on.

I am trying to direct Excel as follows: if k2 contains the number 65, then multiply T2 by.65 (or) if k2 contains the number 70, then multiply T2 by .50, otherwise (if k2 doesn't = 65 or 70) return the value in T2

This is what I have, but I am apparently I am missing something or have something out of order.

=IF(K2=Sheet2!$A$1,(T2*0.65),"t2" or IF(K2=Sheet2!$A$2,(T2*.50),”t2”

Thanks so much for your help!

 

[JackDanIce]

Welcome to the board. Try:

=T2*IF(K2=65,0.65,IF(K2=70,0.50,1)

 

[V_Malkoti]

=if(k2=65, t2*0.65, if(k2=70, t2*0.5, t2))

 

[melmartin]

Well. There was one thing I didn't think of and now need to adjust the formula =T2*IF(K2=65,0.65,IF(K2=70,0.50,1) that JackDanIce gave me (it worked great, by the way - thanks).

If the number in K2= 65, 66, 67, 68 or 69, I need it to multiply T2 by .65. If it is >=70, then I need it to multiply T2 by .50. Anyone know how to adjust it?

Thanks in advance!

 

[Special-K99]

=t2*if(and(k2>=65,k2<=69),0.65,if(k2=70,0.50,1)