asked 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)

asked
User Przemaas
by
7.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.

answered
User Dark Templar
by
8.5k points
10 votes

Answer:

(C2+C3+C4+C5)-B1

Step-by-step explanation:

answered
User Michaellee
by
8.0k points