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))
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))