Question 192224 • Computer Applications I-Sem A -CA- 39901A
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.