IF AND OR structure

[poikl]

Hi, I hope you can please reply. I'm trying to make a formula in Row2 ColO, to find if the right most character in ColG is T and if A2 either equals A1 or equals A3 and that G2 doesn't equal G2 or G3 (the respective Row which A2 DOES equal) then in ColO it should show G2, otherwise leave blank.
My big problem is how to avoid getting a "blank" result in ColG when for instance A2 equals A1 and G2 also equals G1 but does NOT equal G3?

 

[yky]

Sounds to me what you want is G2 doesn't equal G1 AND G3.

 

[poikl]

I'm only interested to know and need the formula structure the G2 comparison to G1 and or G3 ONLY if two other conditions are met: 1) A2 equals either A1 or A3 and 2) Right most character of G2 = "T"

 

[Michael M]

Might need a rethink here.....

G2 doesn't equal G2 or G3 ????

 

[Michael M]

Maybe....but UNTESTED

=IF(AND(OR(A2=A1,A2=A3),RIGHT(G2,1)="T"),IF(OR(G2=G1,G2=G3),G2,""))

 

[poikl]

Hi Micheal, Thank you for your formula,... but it shows result as "FALSE" down most of the copied and pasted column (ColO),....except in the few cells where the criteria should match, There it shows BLANK.
So if you can just please fine-tune it, then it might work

 

[Michael M]

Sorry.....quotes in the wrong place

=IF(AND(OR(A2=A1,A2=A3),RIGHT(G2,1)="T"),IF(OR(G2=G1,G2=G3),G2),"")

 

[poikl]

Thank You Micheal again. It so much better but it shows now "FALSE" in ColO (when criteria seems to have been met), instead of contents in ColG.

 

[yky]

Does this formula work?

=IF(AND(RIGHT(G2,1)="T", OR(A2=A1, A2=A3),G2<>G1,G2<>G3),G2,"")

 

[poikl]

Does this formula work?

=IF(AND(RIGHT(G2,1)="T", OR(A2=A1, A2=A3),G2<>G1,G2<>G3),G2,"")

Sorry Micheal, this now doesn’t go on at all even when all the conditions were met.