Give the Logical Function for the Following: If Cell B7

Multiple Choice

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)