larry brooks asked 9/13/2011 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?