Answer:
=IF(AND(B2>3000,02>2000),"Bonus","No Bonus")
Explanation:
A nested If statement is used when 1 or more conditions are to be tested. The result of the nested function depends based on the true value of the function.
i.e. If the nested statement is true, certain operations are to be done otherwise, do something else. In other words, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False.
The syntax of a nested function goes thus
IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 ))
This would be equivalent to the following in Excel
= IF(condition1,"value_if_true",value_if_false)
Base on the above explanation, only option B is right.
And what it does is that
it checks if cell B2 is greater than 3000 AND cell 02 is greater than 2000.
If both statement are true, "Bonus" will be the output result
If one ore both statement are false, "No Bonus" will be the output result
