Evaluting employee performance
Now to calculate the profit (or loss!) for each day using the
Output ($)
and Total Costs ($)
you found in the previous exercises. You'll also evaluate the employee's performance each day as either good
or bad
, depending on the net income and the number of products finished.This exercise is part of the course
Data Analysis in Google Sheets
Exercise instructions
- Calculate the
Net ($)
by subtracting theTotal Costs ($)
from theOutput ($)
. - In the
Performance
column, returngood
if theNet ($)
for the day was positive, greater than0
, ANDFinished
was greater than10
, and returnbad
, otherwise.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
