$=$IF$($D$2=$"yes"

A

B

C

D

E

F

G

H

Sales

Associate's Last

$1$

Name

Annual Sales

Potential

Eligible for

Commission

Total

Commission

Commission?

Earned

Salary

Earnings

$2$ Ahjab

$3$

Anderson

$4$

$5$

$6$

$7$

$8$

$9$

$10$

$11$

$12$

$13$

$14$

$15$

$16$

$17$

$18$

Commission Rat

Sales Associates

On the Sales Data worksheet, use a formula to calculate the actual commission for each sales associate.

a$.$ In cell E$2,$ enter a formula to display the commission value from cell C$2$ only if the value in cell D$2$ is yes. If the value in D$2$ is not yes, then the value in E$2$ should be $0.$ Use appropriate cell references.

b$.$ Copy the formula to cells E$3$:E$9.$

On the Sales Data worksheet, calculate the total earnings for each sales associate.