Notice: Payments for answers will end 4/10/2017. Click for more info.
You have new items in your feed. Click to view.
Question and answer
Q: 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%
A: 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. ]
Get an answer
Original conversation
User: How would you write a formula to calculate the average of your monthly expenses?

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 6998|

Question
Asked 3/12/2012 8:22:18 PM
0 Answers/Comments
New answers
Rating

There are no new answers.

Comments

There are no comments.

Add an answer or comment
Log in or sign up first.
26,399,364 questions answered
Weegy Stuff
S
P
P
L
P
P
P
Points 124 [Total 1860] Ratings 3 Comments 94 Invitations 0 Offline
S
Points 57 [Total 68] Ratings 4 Comments 17 Invitations 0 Offline
S
Points 30 [Total 30] Ratings 3 Comments 0 Invitations 0 Offline
S
Points 16 [Total 16] Ratings 0 Comments 6 Invitations 1 Offline
S
L
Points 15 [Total 112] Ratings 0 Comments 15 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Offline
S
Points 5 [Total 5] Ratings 0 Comments 5 Invitations 0 Offline
S
Points 3 [Total 3] Ratings 0 Comments 3 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.