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 ejercicio forma parte del curso
Análisis de datos en Google Sheets
Instrucciones de ejercicio
- 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.
Ejercicio interactivo práctico
Convierte la teoría en acción con uno de nuestros ejercicios interactivos
