Multiple IF logic Tests

[F4TMAN]

Hello,

I'm trying to condense the long formula i currently have and was hoping for some guidance on the possibility or narrowing the formula

Here are the logical test

If Cell O1 ,P1 ,Q1 has value then takes Q1 value first. if only Q1 is blank & O1 and P1 has value then take P1 if only P1 blank & O1 and Q1 has value then take Q1 if only O1 blank & P1 and Q1 has value then take Q1 If any Two blank Take filled one value if all blank not take any value

Below is the current formula that i would like to shorten if possible

=IF(IF(AND($O2<>"",$P2<>"",$Q2<>""),$Q2,IF(AND($Q2="",$P2<>"",$O2<>""),$P2,IF(AND($P2="",$Q2<>"",$O2<>""),$Q2,IF(AND($O2="",$P2<>"",$Q2<>""),$Q2,IF(AND($O2="",$P2=""),$Q2,IF(AND($O2="",$Q2=""),$P2,IF(AND($P2="",$Q2=""),$O2,IF(AND($O2="",$P2="",$Q2=""),""))))))))=U$1,$T2,0)

 

[mikerickson]

So what you want is the right most filled cell of the three.

=IF(Q1<>"", Q1, IF(P1<>"", P1, O1&""))