Write a formula $($using the IF$()$ function$)$ in cell G$8$ to only display total sales that are

numerically greater than the average in cell B$5($this means that total sales exactly equal

or less than the value of B$5$ should display $$0).$

Hint: Make sure that you understand the difference between $>$ and $>=.$

For example, suppose the average total sales $($cell B$5)$ for all salespersons is $$10,000$ and

Salesperson A$$s Total Sales $($column $$F$)$ is $$9,000($or even $$10,000$ exact$).$ In this case,

the result of your formula will display $$0$ in cell G$8.$ If$,$ on the other hand, their Total

Sales in column F were $$11,000($or even $$10,000\mathrm{.}01),$ then your formula should display

$$11,000($the Total Sales value$)$ in the $$Above Average Total Sales $($or column $$G$$ for

that salesperson$)$