Clipboard F 61 2 3 A First Name 4 Rachel 5 Deeyana 6 Diana 7 Glen Ready 8 Wallace 9 Rachelle 10 Helen 11 Stephanie H B Font x B Paws Assisting Today's Youth Professional Service Staff Performance Rating J C Ask me anything Last Name Burnat Foster Watson Cross Hunt Jackson Dog Trainer Dog Trainer Dog Trainer O'Neill Veterinarian Quintana Veterinarian Service Staff Title Dog Trainer Dog Trainer Dog Trainer 3: 2 3 2 2 3 Alignment 2 1 Salary $15,000 $5,000 $4,500 $18,000 $15,000 $7,700 $2,850 $15.000 0 Bonus Amount X Number G 40 H Formatting Table Styles Styles Task Instructions K Cells Editing f. In cell F4, enter a formula, using a nested IF function, to calculate the Bonus Amount using the following function arguments: enter D4-3 as the Logical test argument, enter E4.1 as the Value_if_true argument, and enter IF(D4=2, E4*.05, 0) as the Value_if_false argument. %40 M 9:26 PM 1/1/2020