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

Oddman Profile
Oddman answered
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.

Answer Question