Simplified version of my previous
=IF(AND(OR(CH2={0,1,2,19,20,21,22,23}),OR(AND(OR(CF2={"LONDON","PARIS","WASHINGTON DC"}),CG2="Wednesday"),AND(OR(CF2={"ATHENS","ATLANTA","ROME"}),CG2="Thursday"))),"Y","N")
Simplified version of my previous
=IF(AND(OR(CH2={0,1,2,19,20,21,22,23}),OR(AND(OR(CF2={"LONDON","PARIS","WASHINGTON DC"}),CG2="Wednesday"),AND(OR(CF2={"ATHENS","ATLANTA","ROME"}),CG2="Thursday"))),"Y","N")
Good luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks