$"$In cell L$2$ on the MLB atbats worksheet, enter a VLOOKUP formula that brings in the last name of the batter from the MLB Players worksheet $($use batter$\_$id for the lookup value$)$

a$.$ Copy the formula in cell L$2$ to the remaining cells $($through L$3681)"$

In cell O$5$ on the MLB atbats worksheet, enter a formula to return the number of at$-$bats in the worksheet that were in the bottom of the $4$th inning and resulted in a Double

In cell S$3$ on the MLB Games worksheet, enter a SUMIFS formula that returns the total runs scored by the home team when "tex" was the home team and "hou" was the away team

In cell S$5$ on the MLB Games worksheet, enter an AVERAGEIFS formula that returns the average attendance at Fenway Park when the away team scored less than $5$ runs and the home team scored more than $5$ runs

"After reading the commission policy in A$20$ and A$21$ on the Sales Commissions worksheet, enter an IF formula to calculate the sales commission for each salesperson listed in column A$.$

a$.$ Place the sales commission formulas in column C

b$.$ Be sure to use cell references in your formulas rather than manually entering amounts

c$.$ The same formula should be used for all salespeople"

$"$In cell O$2$ on the MLB Games worksheet, enter a formula using IF and AND that returns a result of $1$ if the visiting team scored $8$ or more runs and the game lasted more than $9$ innings; the formula should return $0$ otherwise

a$.$ Copy the formula in cell O$2$ to the remaining cells $($through O$2432)"$

$"$In cell P$2$ on the MLB Games worksheet, enter a formula using IF$,$ OR$,$ and AND that returns a result of $1$ if the attendance exceeded $40,000,$ the home team scored $5$ runs or more, and either the game lasted more than $9$ innings or the elapsed time was more than $210$ minutes; the formula should return $0$ otherwise

a$.$ Copy the formula in cell P$2$ to the remaining cells $($through P$2432)"$