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".

I'll just go ahead and answer this, since I found someone who fixed it -- in case it helps someone. First off, it should be noted that the ab, cd, etc. are placeholders and not actual strings. Second, for some strange reason the "general" format sometimes makes it difficult to operate on logical expressions. Who knows why, but the OR() vars needed no quotes, and the others did...go figure.

I've definitely become a Mac user over the last few years, but this is one area where #%*! Apple. So much of Excel's developer stuff is missing or not as good. Hope this helps another iPerson.