Ask Question
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