please solve formulas :)

1 9 An infield fly in baseball is called to prevent the defense from recording an easy double play, When an infield fly occurs, the batter is automatically out once the ball is touched by a fielder or hits the ground and the baserunners must go back to their bases (though they may "tag up if they wish). An infield fly occurs when the following conditions are met: (1) there is a force out at third base (this means that there are runners on first base and second base), (2) there are not two outs, and (3) the batter hits a catchable fly ball to the infield or the shallow outfield. The table below highlights 30 baseball scenarios. Complete the tasks below to determine if the umpire should declare an infield fly. Task # Points Task Description Use the AND function with appropriate arguments in orl H11 to determine if there as a force out at third base. There is a force out at third base if "Runner on It and "Runner on 2nd are both Yes 1 Copy your function in cell H11 and paste it down to complete the Force Thiet cokmn of the table. Use the OR function with appropriate arguments in cell 111 to determine if there is a "fy Ball". There is a "Fly Bar it "Catchable Fly Ball fia] Hit to the "Infield" (oell E11 is "Yes") or "Shallow Outfield (ell F11 is yes") Copy your function in cell 111 and paste it down to complete the "fy Balcolumn of the table. Use the NOT function in cell 11 to determine if there are "Not 2 Outs". Use the "Outs" column in your determination Copy your function in col 11 and paste it down to complete the "Not 2 Oues" colunt of the table. Use the AND function in cell li to determine all to the conditions are met for an infield fly to be declared. These conditions are there must be a force out at third (H11 -TRUE), there must be a catchable flyball it to the infield or shallow outfield (111 - TRUE), and there must not be 2 outs 011 - TRUE) 2 3 3 7 4 1 5 7 6 1 7 3 8 00 . Copy your function in cell Kit and paste it down to complete the "Infield Pyolun of the table B D E F G H 1 2 3 An infield fly in baseball is called to prevent the defense from recording an easy double play. When an infield fly occurs, the batter is automatically out once the ball is touched by a fielder or hits the ground and the baserunners must go back to their bases (though they may "tag up" if they wish). An infield fly occurs when the following conditions are met: (1) there is a force out at third base (this means that there are runners on first base and second base), (2) there are not two outs, and (3) the batter hits a catchable fly ball to the infield or the shallow outfield. The table below highlights 30 baseball scenarios. Complete the tasks below to determine if the umpire should declare an infield fly Fly Ball Not 2 Outs Infield Fly Yes No OOONO 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Yes Yes No Catchable Fly Ball Hitto... Scenario Runner on 1st Runner on 2nd Infield Shallow Outfield Outs Force Third 1 Yes No No Yes 2 Yes No Yes No 3 No Yes 4 No Yes No No 2 5 Yes Yes No No 6 NO No No Yes 1 7 Yes Yes NO No 1 8 Yes 2 9 Yes Yes No No 10 Yes Yes No Yes 11 NO No No No 12 Yes Yes No 13 No Yes No Yes 14 No Yes No Na 15 Yes Yes 16 No Yes No 17 NO Yes Yes No 18 Na No Yes No Yes OOONONO Yes No No F A B H G 1 9 1 10 11 12 13 14 15 16 0 F No Yes No No Yes No 2 0 E No No No Yes No No Yes Yes Yes Yes No 2 1 0 17 O C Yes Yes No Yes No No Yes No No No No Yes Yes No No No No Yes Yes NO No No 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 D Yes Yes No Yes Yes Yes Yes No Yes No No Yes Yes No Yes Yes No No Yes NO No No 0 0 18 19 20 21 22 23 24 25 26 27 28 29 30 NO Yes Yes Yes No No No No No No No Yes No No No Yes Yes No Yes Yes Yes 0 O 1 1 0 0 1 Yes 0 No No No NO 1 2 Yes 2