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.Este exercício faz parte do curso
Data Analysis in Google Sheets
Instruções do exercício
- 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.
Exercício interativo prático
Transforme a teoria em ação com um de nossos exercícios interativos
