If a range contains 'Football', 'Rugby', or 'Golf', return value 'Sporty'

I am comfortable using simple IF statements but need some pointers using IF with multiple clauses.

If A range of cells contains either Option A, Option B, or Option C, return 'Needs'. If the range doesn't contain any of the 3 options, return 'no needs'.

If I was just comparing one cell with one possibility I would do similar to the following:

=IF(C4="Option 1", Needs, No Needs)

How do I adapt this when referring to a range, and when referring to more than one possible vales?


Many thanks guys

Henry

Hi Henry, perhaps

Formula:

Please Login or Register  to view this content.

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Good question Tony: I had in mind If ANY cell in the range contains ANY of the possible options.

Thank you to everyone for the responses - each has worked in its own way.

I wonder if there is a limit to how long a formula can be? because I have around 30 different possible options!

The word "contains" is a bit ambiguous, also - what if you had an entry of "Association Football", or "Rugby Union", or "Crazy Golf"?

Pete