Q: How would you construct an excel formula to calculate your grocery expenses as part of your total expenses? For example, if your grocery expenses for the month were $230; what percent would that be

of your total expenses $2, 300?

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. ]

sharpies|Points 6116|

ephraimzRN|Points 1366|

Question

Asked 1/4/2012 3:33:34 PM

0 Answers/Comments

Rating

There are no new answers.

26,520,744 questions answered

There are no comments.