cell F$4,$ enter a formula, using a nested IF function, calculate the Bonus Amount using the following functi arguments: enter D$4=3$ as the Logical$\_$ test argument, enter EA$*\mathrm{.}1$ as the Value$\_$true argument, and enter IF$($D$4=2,54*\mathrm{.}05,0)$ as the Value$\_$if false argument.ENG IN$12$:$05$ F$1/1/20212$:$05$ PM$6/21/2022$CEdelete