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".

Respuesta :

Answer:

=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.

As per the question the and function and argument of the H11 cell is to determine the focus of the third base. The if runner on the first and runner in the second.

  • As the AND function takes conditional inputs and tests if each of them are TRUE.
  • The  scales to the multiple inputs but this example only has 2 conditions. It is important to remember that we want to compare a string so our condition must be "Yes", not just Yes.

Learn more about the function with appropriate arguments in cell H11 to determine.

brainly.com/question/8595539.

ACCESS MORE
EDU ACCESS