Hi there,

Hopefully a quick and easy one, how would I insert a range or array of criteria for an IF statement (short of using lookups unless that's the only way?)

Simplifying my formula I have:

=if(e45={"OCT","NOV","DEC"},"YES","NO"}

what would the syntax for an array be in an if statement??

Many thanks in advance,

Mike