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.
19,262,829 questions answered
Popular Conversations
Which of the following sentences is written in the passive voice? ...
Weegy: The sentence with the active voice is: The chairman told me that the legislature passed the bill. User: ...
1/31/2015 11:17:44 AM| 2 Answers
How long was George Washington a president?
Weegy: George Washington (February 22, 1732 [O.S. February 11, 1731] ? December 14, 1799) was the first President of ...
1/31/2015 1:03:26 AM| 1 Answers
Weegy Stuff
S
1
L
L
Points 36 [Total 7102]| Ratings 1| Comments 26| Invitations 0|Offline
S
L
P
L
P
Points 36 [Total 6811]| Ratings 0| Comments 36| Invitations 0|Offline
S
Points 8 [Total 153]| Ratings 0| Comments 8| Invitations 0|Online
S
1
L
1
L
P
P
L
P
P
Points 7 [Total 15789]| Ratings 0| Comments 7| Invitations 0|Offline
S
Points 4 [Total 69]| Ratings 0| Comments 4| Invitations 0|Offline
S
L
Points 3 [Total 2124]| Ratings 0| Comments 3| Invitations 0|Offline
Points 0 [Total 0]| Ratings 0| Comments 0| Invitations 0|Offline
Points 0 [Total 0]| Ratings 0| Comments 0| Invitations 0|Offline
S
Points 0 [Total 0]| Ratings 0| Comments 0| Invitations 0|Offline
S
Points 0 [Total 0]| Ratings 0| Comments 0| Invitations 0|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.