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 ?
- A.
Distinction
- B.
Fail
- C.
#VALUE!
- D.
Pass
- E.
Question not attempted
Attempted by 105 students.
Sign up free to check your answer
Sign up freeLoading lesson…

