Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Secrets Of Analytical Leaders Insights From Information Insiders

Authors: Wayne Eckerson

1st Edition

1935504347, 9781935504344

More Books

Students also viewed these Databases questions