Question and answer
• How would you write a formula to calculate the average of your monthly expenses
Add up the total expenses of the month and divide by the number of days in the month.
Get an answer
Original conversation
User: • How would you write a formula to calculate the average of your monthly expenses

Weegy: Add up the total expenses of the month and divide by the number of days in the month.
ahart33|Points 301|

User: • How would you construct an Excel formula to calculate your grocery expenses as part of your total expenses? For example, if your total grocery expenses for the month were $230; what percent would that be of your total expenses of $2,300? (answer: 10%).

Weegy: If you know how to use formulas in excel, you can tag grocery expenses using a numeric or string value and then use SUMIF to calculate its sum. [ The % will then be another cell which uses both the total expense and grocery expense cells using another formula. ]
sharpies|Points 1968|

Question
Asked 6/18/2011 1:02:18 PM
Updated 1/4/2012 2:30:29 PM
2 Answers/Comments
New answers
Rating

There are no new answers.

Comments
total of all monthly expenses / number of months
Added 1/4/2012 2:30:28 PM
Add an answer or comment
Log in or sign up first.
17,604,795 questions answered
Popular Conversations
The pressure of ocean water increases as depth increases. User: The ...
Weegy: It originates in the Gulf of Mexico and, as the Florida Current, passes through the Straits of Florida and then ...
9/30/2014 6:27:02 AM| 3 Answers
The densest ocean water is generally found a. in the surface ...
Weegy: A. in the surface zone User: In which zone is ocean temperature most affected by the weather? a. transition ...
9/30/2014 6:07:25 AM| 3 Answers
What is one way to describe elements? A. They are the smallest ...
Weegy: A chemical element is a pure chemical substance consisting of one type of atom distinguished by its atomic ...
9/30/2014 5:22:18 PM| 2 Answers
simplify x(2x + 3) + (x - 3)(x - 4)
Weegy: 12 + 3(2x - 3) + 4. = 12 + 6x - 9 + 4; = 6x + 7
9/30/2014 2:50:25 PM| 2 Answers
6p - 21 = 3p - 12 A. 1 B. 3 C. –3 D. –1 ...
Weegy: 3-3 = 0 User: 78 = -2(m + 3) + m A. –28 B. –42 C. –72 D. –84
9/30/2014 1:26:57 PM| 2 Answers
Captain cook
9/30/2014 12:56:52 PM| 2 Answers
What two minerals can be identified by taste?
9/30/2014 11:38:46 AM| 2 Answers
Weegy Stuff
S
R
L
1
1
P
C
1
P
1
1
L
P
C
P
C
1
P
C
L
P
C
1
P
C
P
C
P
C
L
Points 3316 [Total 27714]| Ratings 8| Comments 3236| Invitations 0|Offline
S
L
1
L
P
C
1
Points 2951 [Total 9482]| Ratings 12| Comments 2831| Invitations 0|Offline
S
L
P
C
L
P
C
P
C
L
P
C
P
C
P
C
Points 2829 [Total 20001]| Ratings 12| Comments 2709| Invitations 0|Offline
S
L
C
P
C
1
L
L
P
C
1
Points 2761 [Total 18700]| Ratings 19| Comments 2571| Invitations 0|Offline
S
L
1
1
1
1
L
1
L
Points 2595 [Total 12375]| Ratings 0| Comments 2595| Invitations 0|Offline
S
1
L
1
L
P
P
L
Points 983 [Total 12229]| Ratings 0| Comments 983| Invitations 0|Offline
S
L
P
C
P
C
1
L
P
C
L
P
C
P
C
P
C
P
C
Points 864 [Total 19395]| Ratings 2| Comments 844| Invitations 0|Offline
S
L
Points 733 [Total 1402]| Ratings 0| Comments 733| Invitations 0|Offline
S
1
L
L
Points 671 [Total 5794]| Ratings 5| Comments 621| Invitations 0|Online
S
P
C
L
P
L
1
Points 177 [Total 6234]| Ratings 2| Comments 157| Invitations 0|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.