In MS Excel, the following formula is entered in cell D2 :…

RSSB Computer Instructor 2026

In MS Excel, the following formula is entered in cell D2 :

=IF(AND(B2>=40,C2>=40),IF(B2+C2>=90,"Distinction","Pass"),"Fail")

If the values in cells B2 and C2 are 45 and 42, respectively, what will be the result returned by the formula ?

  1. A.

    Distinction

  2. B.

    Fail

  3. C.

    #VALUE!

  4. D.

    Pass

  5. E.

    Question not attempted

Attempted by 105 students.

Sign up free to check your answer

Sign up free

Explore the full course: Bpsc

Loading lesson…