Question

How do I write a formula for this condition on excel?

The salesperson receives a bonus of $300 for non food orders if the amount ordered is greater than $5000 for a particular sale.

Column E has a list of name of orders such as "souvenirs", "clothing", "food" and "jewelery"

Column B has a list of the amount ordered in currency

the condition has to be formatted for the entire column C

Answer 1

Amount Ordered	Bonus		Name of Orders
5001	300		souvenirs	greater than 5000
5500	300		clothing
7000	0		food
4000	0		jewelery
4000	0		food
8000	300		clothing
5000	0		food
7000	300		jewelery
9000	0		food

FORMULA USED: = IF(AND(B2 > 5000, E2 <> "food"), 300, 0)

The above formula is true when Amount ordered is greater than 5000 and is non food category

SCREENSHOT:

IF(AND(B2> 5000, E2"food"), 300, 0) Amount Ordered Bonus Name of Orders souvenirs clothin food ewele food clothin food ewele food 300 300 0 0 0 300 0 300 0 reater than 5000 5001 5500 5000 9000 12 13

Please go through the screenshot and formula and try it on your own, if you need any help then just message me.

Give me a thumbs up. Thanks.