Get startedGet started for free

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

View Course

Exercise instructions

  • Calculate the Net ($) by subtracting the Total Costs ($) from the Output ($).
  • In the Performance column, return good if the Net ($) for the day was positive, greater than 0, AND Finished was greater than 10, and return bad, otherwise.

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise