question for multiple comparisons in if statements

[largeselection]

Hello,

I was wondering how to correctly get an if statement to reference multiple entries.

For example.

I have a column

1
2
3
4
5
6
7


I want to add another column that says something like
if(B1=2,3,4, "Group C", "")

so if the value in cell B1 = 2, 3, or 4, then label "group C" otherwise leave the cell blank.

So how do I put the 2,3 or 4 part in correctly.

 

[dave3009]

Perhaps

=IF(OR(B1={2, 3, 4}), "Group C", "")

HTH


Dave