in excel or google sheets, is there an 'if' function equivalent to the sql 'when A in (X,Y,Z)

Question

In excel or google sheets, is there an 'if' function equivalent to the sql 'when A in (X,Y,Z). Currently I use: if(and(A=X, A=Y, A=Z), then, else). Wondering if there is an: if(in(X,Y,Z)=A, then, else).

Thanks

Something along the line of If(IsError(Match(A, {X,Y,Z},0)), else, then) — chris neilsen
– chris neilsen, Commented Jan 24, 2015 at 20:07
Or have a look at these answers stackoverflow.com/questions/8618168/… — Tom Sharpe
– Tom Sharpe, Commented Jan 25, 2015 at 10:54

Community · Accepted Answer · 2017-05-23 10:26:28Z

2

Just updating the answers Here slightly, for Excel and Google Sheets

=IF(OR(A1={1,2,3,4,5}),"Yes","No")

or

=IF(ISNUMBER(MATCH(A1,{1,2,3,4,5},0)),"Yes","No")

For Open Office

=IF(OR(A1={1;2;3;4;5});"Yes";"No")

or

=IF(ISNUMBER(MATCH(A1;{1;2;3;4;5};0));"Yes";"No")

edited May 23, 2017 at 10:26

CommunityBot

11 silver badge

answered Jan 25, 2015 at 12:53

Tom Sharpe

35.1k5 gold badges29 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

in excel or google sheets, is there an 'if' function equivalent to the sql 'when A in (X,Y,Z)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related