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 $2300?

Question

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 $2300?

1 Answers

Answer Question

Answer 1

Multiply the fraction by 100%. The fraction of interest is your grocery expense (230) divided by your total expense (2300).
230/2300*100% = 1/10*100% = 10%
______
In Excel, if the grocery expense is in A1, and the total expense is in A2, the formula in A3 might be
=A1/A2 Then cell A3 would be formatted to show numbers in % to as many decimal places as you might want.