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 no matter what cell H45 is.
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 is using an IF statement to check if B7 equals 12. If it does, then it checks if B10 equals 10. If it does, then the function returns "YES". If it doesn't, then it returns a blank space. If B7 does not equal 12, then the function always returns 7. The syntax for the function is correct in choice C.

Give the Logical Function for the Following: If Cell B7