Question 147342 • TX-Business Information Management (BIM) I
A nested function places one function inside another as an argument. Here, AND(B2>3000,C2>2000) checks whether both conditions are true, and IF uses that result to return “Bonus” or “No Bonus.” Therefore, the correctly formatted formula is =IF(AND(B2>3000,C2>2000),“Bonus”,“No Bonus”).
AI-written and checked against the verified answer.