If Statement help

[erniepoe]

Hi all,

I know I'm close with this one, but need help getting across the finish line. Basically, if column T = yes, column J = SGIP, and column K contains the words "signed contract", i want to multiply the value in column S by .2.

Otherwise, if the value in column T = yes (regardless of what is in columns J or K, i want to mutiply column T by .4.

And if course, if column T is No, the value should be 0.

Any help is much appreciated, thank you!

-Ernie


=IF(T2="No",0,IF(AND(T2="yes",J2="SGIP",SUM(COUNTIF(K2,{"*signed contract*"}),S2*0.2)),IF(T2="YES",S2*0.4),0))

 

[jtakw]

Hi,

Try this out:

Excel 2010
	A
1	0
Sheet2

Cell Formulas
Range	Formula
A1	=IF(T2="Yes",IF(AND(J2="SGIP",ISNUMBER(SEARCH("signed contract",K2))),S2*0.2,S2*0.4),0)

 

[erniepoe]

Success! Thank you so much!

 

[jtakw]

You're welcome.