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.
23,845,041 questions answered
Weegy Stuff
S
Points 162 [Total 559] Ratings 0 Comments 162 Invitations 0 Offline
S
P
P
Points 142 [Total 949] Ratings 0 Comments 142 Invitations 0 Offline
S
1
L
L
P
R
P
L
P
Points 106 [Total 11279] Ratings 0 Comments 106 Invitations 0 Offline
S
L
P
Points 46 [Total 2114] Ratings 0 Comments 46 Invitations 0 Offline
S
Points 7 [Total 17] Ratings 0 Comments 7 Invitations 0 Offline
S
Points 4 [Total 904] Ratings 0 Comments 4 Invitations 0 Offline
S
Points 4 [Total 4] Ratings 0 Comments 4 Invitations 0 Offline
S
R
Points 2 [Total 438] Ratings 0 Comments 2 Invitations 0 Offline
S
Points 2 [Total 2] Ratings 0 Comments 2 Invitations 0 Offline
S
Points 1 [Total 2] Ratings 0 Comments 1 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)