Imbedding an OR statement to connet with a list

[Klarkin]

I have a rule in column A to select a name from a dropdown list and I wish to add rules into column B that associates an hourly rate for each team member.

I've therefore used IF statements for example IFA2="Alan",40,0).This works fine but if I want to add two tea members with the same rate I was trying to use an OR statement and I am getting a#VALUE error.

For example =IF(OR(A2="Katie","Dave"),25,0)

All assistance gratefully received

KL

 

[Fluff]

Try either
=IF(OR(A2="Katie",A2="Dave"),25,0)
or
=IF(OR(A2={"Katie","Dave"}),25,0)

 

[Klarkin]

Clean and simple. Thank you, much appreciated

 

[Fluff]

Glad to help & thanks for the feedback

 

[Greg Truby]

a) I'm moving this out of the Questions in Other Languages forum. It belongs in the main forum

=IF(OR(A2="Katie","Dave"),25,0)

b) Blech! I would refrain from using an IF statement at all. I'd put the pay rates elsewhere in a lookup table and fetch the rate using INDEX() and MATCH() or VLOOKUP(). This makes adding new people as simple as adding a row to your table. As it is now, any time you have a change in staff, you gotta rewrite your formula. Again -- blech!