You want to give a bonus to employees who have worked more than 3 years and have

Fantastic news! We've Found the answer you've been seeking!

Question:

You want to give a bonus to employees who have worked more than 3 years and have sales over $10,000. Which formula should you use? =IF(AND(A1 > 3, B1 > 10000), "Bonus", "No Bonus") =IF(A1 > 3 & B1 > 10000, "Bonus", "No Bonus") AND(IF(A1 > 3, IF(B1> 10000, "Bonus", "No Bonus"))) =IF(A1 > 3 AND B1 > 10000, "Bonus", "No Bonus")