229k views
13 votes
Carrie needs to keep a budget for her department. Each employee in her department sends her travel expenses. In cell, C2, C3, C4, and C5, she enters the total of each employee’s expenses. In cell B1, she enters the original amount of money the department was allotted for spending. What formula should she use to calculate the amount of money the department currently has?

=B1 -(C2+C3+C4+C5)
=B1-C2+ B1-C3+B1-C4+B1-C5
= (C2+C3+C4+C5)-B1
=(B1+C2+C3+C4+C5)

User Przemaas
by
4.6k points

2 Answers

14 votes

Answer:

=(C2+C3+C4+C5)/4

Step-by-step explanation:

add all numbers together then div. by the total amount of numbers is how you get the average.

User Dark Templar
by
5.2k points
10 votes

Answer:

(C2+C3+C4+C5)-B1

Step-by-step explanation:

User Michaellee
by
5.1k points