,.. |"Wrap Text Currend Assignment Tasks |Merge & Center , | $ . Four J's Painting & Find & Use the IF function to complete the "Time Bonus $" column of table 1. If an employee earns a time bonus (i.e, the corresponding cell in the "Time Bonus?" column is TRUE), then "Time Bonus $" is the "lob Pay" for that project times the bonus percentage in cell M11. Otherwise "Time Bonus $" is 0. 8 points rences (e.g. B16:C30 yee Wage Information Bonus Information Jake Jennifer 10% $48 Outcome - Table 1 - Painting Projects Hours Worked Hourly Wage Difficulty Quality Time Bonus? Outcome Bonus? Job Pay Time Bonus $ Outcome Bnus Total Pay $2,808 $2,000 4,472 $1,974 $4,056 $1,786 $2,652 $1,728 $2,496 $2,100 $3,478 $2,448 $3,360 $2,726 $3,102 YES $2,808 $2,000 $4,472 $1,974 $4,056 $1,786 $2,652 $1,728 $2,496 $2,100 3,478 $2,448 $3,360 $2,726 $3,102 $2,400 $2,256 3,250 $3,050 $3,792 NO BONUS NO BONUS NO BONUS NO BONUS 40 $50 86 NO BONUS NO 78 38 BONUS NO BONUS NO BONUS BONUS NO BONUS NO BONUS NO BONUS NO BONUS BONUS BONUS NO BONUS BONUS NO BONUS NO BONUS 36 48 S52 S50 $47 $48 74 NO 70 58 $2,256 $3,250 $3,050 $3,792 NO YES 1NO BONUS Table 3 - Employee Summary Average Cost/Job. #DIV/0! True Cost/Hour #DIV/0! Total Pay #of Touch-ups Cost Touch-ups Employee # of Jobs Total Hours , $400 Cost Google Spending Event Profit | Past Events | PivotTable Quest - 4:20 PM Desktop 4: 10.220017