Help with combining IF and AND with OR (I guess)

[nr6281]

Hi All,

I am trying to come up with a if and or formula combined with AND i guess.

But the part of having >6 or <12 to populate a target I am not quite able to get my head around it.

I have attached the ask in the comments.

Based on Column C Tenure a Target should come up in Column D which is =1.25,1,0.85

Thanks for the help in advance.

[Sam Capricci]

this looks like it will work... =IF(A2="","",IF(AND(OR(A2="t7",A2="rj"),C2<6),1.25,IF(AND(OR(A2="t7",A2="rj"),C2>=12),0.85,IF(AND(OR(A2="t7",A2="rj"),C2>=6),1,""))))

[nr6281]

Thank you Sam,

I finally looked into other treads and got what I need to mend my OG formula to include them

=IF(AND(G2="RJ",J2<=6),1.25,IF(AND(G2="T7",J2<=6),1.25,IF(AND(G2="RJ",J2>12),0.85,IF(AND(G2="T7",J2>12),0.85,IF(AND(G2="T7",J2>=6,J2<=12),1,IF(AND(G2="RJ",J2>=6,J2<=12),1,"PG,PC"))))))

[Sam Capricci]

A bit longer than mine, I incorporated the ANDs and the ORs together but if that’s what works for you, glad you solved it.

Don’t forget to mark the post is solved.

[Sam Capricci]

I can't seem to edit my post, but thanks for marking it as solved, AND thank you for the rep!