Simple AND and OR

[ahmedsadak]

I need some basic help on this i m stuck please if anyone can help ?
sheet attached

 

[ahmedsadak]

can someone help on this please ?

 

[hrayani]

Book1
	A	B	C	D
1	Person	Country	Sales	Answer
2	Joe	UK	150,000	Bonus
3	Greg	Ireland	160,000	No Bonus
4	Rose	UK	20,000	No Bonus
5	Mike	Germany	120,000	Bonus
Sheet1

Cell Formulas
Range	Formula
D2:D5	D2	=IF(AND(C2>100000,(OR(B2="UK",B2="Germany"))),"Bonus","No Bonus")

 

[Fluff]

Another option

=IF(AND(C2>100000,OR(B2={"UK","Germany"})),"","No ")&"Bonus"

 

[ahmedsadak]

Thanks so much great help.

 

[hrayani]

Thanks so much great help.

Glad we could help & thanks for the feedback

 

[Fluff]

For future reference.

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Simple AND and OR (I'm stuck)
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.