IF, AND, OR Nesting - Part of it not working

[jnix612]

I'm never going to understand how to nest. Below is my attempt and Excel is not reading the "Sudan" logic. :banghead:

=IF(AND(I3="Ethiopia",OR(I3="Sudan",T3="No Experience",)),"Yes","No")


The written out logic:
If I3 reads "Ethiopia or Sudan" AND T3 reads "No Experience"
Value if true = Yes
Value if false = No

[SamT]

The OR is wrong. Look at this

OR(I3="Ethiopia",I3="Sudan")
Call that InnerCheck

The AND is
AND(InnerCheck,T3="No Experience")
Call that TheTest

The IF is
If(TheTest,"Yes","No")

Read from bottom to top.
Hope that helps.

[jnix612]

YES! Thank you. :bow:

=IF(AND(OR(I3="Ethiopia", I3="Sudan"), T3="No Experience"),"Yes","No")

[mdmackillop]

For such complex formulae write them in parts in adjoining cells then pull them together. You can also use Evaluate Formula to track errors.

[jnix612]

Thank you for the additional information. I will try it all.