How to do an if statement for a set of numbers?

Suppose I want to apply a particular effect if the month is February, March, April, May, June, September, November or December. I do not wish to apply this if the month is January, July or August.

How would I do this? I tried something like IF(MONTH(cell)=[2,3,4,5,6,9,10,11,12]), but I don't think I know the correct Excel syntax or maybe there's a better way to do this.

Thanks,

Danny

Try:

=IF(AND(MONTH(cell)<>1,MONTH(cell)<>7,MONTH(cell)<>2),...)

Don't you actually mean OR, not AND???

=IF(OR(MONTH(cell)<>1,MONTH(cell)<>7,MONTH(cell)<>2),...)

Originally Posted by Glenn Kennedy

Don't you actually mean OR, not AND???

=IF(OR(MONTH(cell)<>1,MONTH(cell)<>7,MONTH(cell)<>2),...)

No, I ment what I said. Try it with OR - won't work.

OR will return TRUE for all dates. AND returns FALSE for dates in January, July or February.

I just did try it... and you are 100% correct.

LOL, Glenn - I've had more experience with AND and OR than I'd care to admit ...

Or try

Formula:

Please Login or Register  to view this content.

That's a nice option, Hans.

Or

Formula:

Please Login or Register  to view this content.

or

Formula:

Please Login or Register  to view this content.