Need help with an If statement!

[melmartin]

Can someone please help me with this formula. It is almost doing what I need it to do! I need it to take any number in K2 that is 65,66,67,68,69 & multiply the number in T2 by .65. If the number in K2 is >= to 70, I need it to multiply the number in T2 by .50.

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


Thanks in advance!

 

[Joe4]

Please continue in your original thread here: http://www.mrexcel.com/forum/excel-questions/864986-if-then-statement-help-needed.html

All clarifications, directly-related follow-up questions, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).