8th Class Computers Microsoft Excel Question Bank MS-Excel 2010

  • question_answer What would be displayed in a cell, if it contains the following formula? =IF(AND(23 < 4, 45 = 15), "Good", "Bad")

    A) 45                    

    B)        23

    C) Good               

    D)        Bad

    Correct Answer: D

    Solution :

    AND function in the given formula, will evaluate, whether the two conditions, i.e, 23<4 and 45=15, are true or not. If these conditions are true, then 'GOOD' as an output will be displayed, otherwise, output BAD will get displayed.

You need to login to perform this action.
You will be redirected in 3 sec spinner