Question: Give the logical function for the following: If cell B 7 equals 1 2 , check contents of cell B 1 0 . If cell

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.
Group of answer choices
=IF(B7=12,(AND(B10=10,"")(YES)),7)
=IF(B7=12,(AND(B10=10,"YES","")(B10="NO"),7)
=IF(B7=12,(IF(B10=10,"YES", "")),7)
=IF(B10=10,(OR(B7=12,"")"YES")7)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To create a logical function that corresponds to the conditions outlined you can use a combination o... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!