Hello all,

Please let me know if I need to repost due to a confusing or annoying/lengthy setup -- first-timer. In order to get around Mac's lack of importxml, I'm having to do a ton of workarounds. I've never not been able to use "elif" or "else if" and I don't know what I'm telling Excel to do here.

Am I correct that by saying:
=IF(OR(A14="FALSE",F6="TRUE"), ab, IF(F1="TRUE", cd, IF(F2="TRUE", ef, IF(F3="TRUE", gh, IF(F4="TRUE", jk, IF(F5="TRUE", mn, ""))))))

I am saying that ___?:
If it is true that (A14 is false or F6=true), then ab;
else if F1=true then cd;
else if F2=true, then ef;
else if F3=true, then gh;
else if F4=true, then jk;
else if F5=true, then mn;
else blank;
end if;



It will only return the terminal false result in any given case.

So in this case:
A14 is true
F6 is false
F1 is *true*
F2 is false
F3 is false
F4 is false
F5 is false.

And it returns "" rather than the desired result "cd".