Give the logical function for the following: If cell B7 equals 12, check contents of cell B10. If cell B10 is 10, then the value of the function in the string is YES; if not, it is a blank space. If cell B7 does not equal 12, then the value of the function is 7.
A) =IFB7=12,ANDB10=10, "")YES)),7)
B) =IFB10=10,ORB7=12,"")"YES")7)
C) =IFB7=12,IFB10=10,"YES", "")),7)
D) =IFB7=12,ANDB10=10,"YES","")B10="NO"),7)

Question

Quizplus · Accepted Answer

The correct formula is =IF(B7=12,IF(B10=10,"YES",""),7). This checks if B7 equals 12, then it checks if B10 equals 10 to return "YES"; otherwise, it returns a blank. If B7 does not equal 12, it returns 7.

Give the Logical Function for the Following: If Cell B7