Hi All,
Good evening,
I am trying to change an existing IF conditions I have attached the sample file,
Change required in Column "AH" and "AP"
Only for a few set of accounts in REF sheet to have 60/20 only for those tagged as "CR" in column "AB"
This is the formula to add but I dont know how to add with existing conditions meet than 60/20
=IF(SUM((AB2="CR")*(A2=REF!$A$2:$A$13)),60
Current formula in AH is (=IF(AND(AG2=0,OR(G2=J2, AND(G2<>J2,S2<>"RH"),J2="")),(IF(AND(AB2="NCRF",U2="Yes",OR(S2="RJ",S2="T1",S2="T7",S2="RH",S2="T5", S2="T6")),30,IF(AND(AB2="CRIM",U2="Yes",OR(S2="RJ",S2="T1",S2="T7",S2="RH",S2="T5", S2="T6")),50,0))),0)
Current formula in AP is =IF(AO2="",0,IF(OR(AB2="NCRF",AB2="CRIM"),(IF(COUNTIF($AO:$AO,D2&G2)=1,10,0)),0))
Account Numbers are in Ref Sheet and they are on Column A in the data file
Thank you,
Good evening,
I am trying to change an existing IF conditions I have attached the sample file,
Change required in Column "AH" and "AP"
Only for a few set of accounts in REF sheet to have 60/20 only for those tagged as "CR" in column "AB"
This is the formula to add but I dont know how to add with existing conditions meet than 60/20
=IF(SUM((AB2="CR")*(A2=REF!$A$2:$A$13)),60
Current formula in AH is (=IF(AND(AG2=0,OR(G2=J2, AND(G2<>J2,S2<>"RH"),J2="")),(IF(AND(AB2="NCRF",U2="Yes",OR(S2="RJ",S2="T1",S2="T7",S2="RH",S2="T5", S2="T6")),30,IF(AND(AB2="CRIM",U2="Yes",OR(S2="RJ",S2="T1",S2="T7",S2="RH",S2="T5", S2="T6")),50,0))),0)
Current formula in AP is =IF(AO2="",0,IF(OR(AB2="NCRF",AB2="CRIM"),(IF(COUNTIF($AO:$AO,D2&G2)=1,10,0)),0))
Account Numbers are in Ref Sheet and they are on Column A in the data file
Thank you,
