In cell F$4,$ enter a formula, using a nested IF function, to

calculate the Bonus Amount using the following function

arguments: enter D$4=3$ as the Logical$\_$test argument,

enter E$4*.1$ as the Value$\_$if$\_$true argument, and enter

IF$($D$4=2,$ E$4*\mathrm{.}05,0)$ as the Value$\_$if$\_$false argument.