Ask Question
Computers & TechnologyComputers & Technology
29 January, 00:55

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

+1
Answers (1)
  1. 29 January, 04:09
    0
    =IF (B7 = 12, (IF (B10 = 10,"YES", "")), 7) and PRESS ENTER

    Explanation:

    the above logical if function checks the following

    -IF cell B7 is 12, if true, check the value of cell B10, IF cell B10 contains 10 the function should produce YES as output to whatever cell selected, IF B10 is not 10 output of the function should be an empty string, IF B7 is not equal to 12 the the output of the function should be 7.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “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 ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers
You Might be Interested in
Which tab in the Tasks view is used to modify the Current View? View Home Folder Send/Receive
Answers (1)
Assume the array of integers values has been created. Which condition must be used in the indicated area so the loop below will assign max the largest value in values?
Answers (1)
Companies normally pay for PaaS solutions on demand for the resources they consume, usually on a per-user basis. True False
Answers (1)
Arrange the steps in a sequence that you would follow while sorting data in a spreadsheet. In the spreadsheet menu, click the Data option. In the submenu of Data, click the Sort ... option. Select the column to sort. Click OK.
Answers (1)
Encapsulation is the process of "packaging" information prior to transmitting it from one location to another. true or false
Answers (1)
New Questions in Computers & Technology
The part of the computer that provides access to the Internet is what
Answers (2)
Which data type requires the greatest number of bytes in computer memory? A. character B. integer C. single-precision number D. double-precision number E. all require the same amount of storage
Answers (1)
Which one these describe the use of the word wall technique?
Answers (1)
What possible effects could cyber attack have on Johannesburg stock exchange
Answers (1)
Competent communication through technological media like e-mail requires communicators to use clearer language than is usually required in face-to-face communication to make up for the nonverbal cues that are missing. A. True B. False
Answers (1)
Home » Computers & Technology » 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.
Sign Up Forgot Password?