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) =IF(B7=12,(AND(B10=10, "")(YES)),7)
B) =IF(B10=10,(OR(B7=12,"")"YES")7)
C) =IF(B7=12,(IF(B10=10,"YES", "")),7)
D) =IF(B7=12,(AND(B10=10,"YES","")(B10="NO"),7)

Question

Quizplus · Accepted Answer

The logical function checks if B7 equals 12 and if B10 equals 10. If both conditions are true, then the function returns "YES." If B7 does not equal 12, then the function returns 7. The IF function is used to capture both possible outcomes, and the AND function is used to ensure both conditions are met before returning "YES."

Give the Logical Function for the Following: If Cell B7