Ask Question
30 May, 14:43

Use the AND function with appropriate arguments in cell H11 to determine if there is a force out at third base. There is a force out at third base if "Runner on 1st" and "Runner on 2nd" are both "Yes".

+4
Answers (1)
  1. 30 May, 16:31
    0
    =AND ($C11 = "Yes", $D11 = "Yes")

    Explanation:

    The AND function takes conditional inputs and tests if each of them are TRUE. If all of the inputs are TRUE, the function will output TRUE but if any one of them are not the function will output FALSE. This scales to multiple inputs but this example only has two conditions. It is important to remember that we want to compare a string so our condition must be "Yes", not just Yes.

    We also use a relative cell reference, "$", on the columns C and D since we always want to use the "Runner on 1st" and "Runner on 2nd" columns.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “Use the AND function with appropriate arguments in cell H11 to determine if there is a force out at third base. There is a force out at ...” 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