Ask Question
16 August, 22:11

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

+4
Answers (1)
  1. 17 August, 01:10
    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?
Find 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 and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers