View Full Version : [SOLVED:] IF, AND, OR Nesting - Part of it not working
jnix612
08-09-2017, 09:06 AM
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
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
08-09-2017, 10:56 AM
YES! Thank you. :bow:
=IF(AND(OR(I3="Ethiopia", I3="Sudan"), T3="No Experience"),"Yes","No")
mdmackillop
08-09-2017, 12:23 PM
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
08-09-2017, 12:30 PM
Thank you for the additional information. I will try it all.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.