Excel Formula - I would like to calculate what percentage of my monthly income I spend on various expenses?

Basically, I want a table for example, rent, food, misc. Then I want to plug in my income for the month and have it calculate what percentage of my income I spend on each item on the table. Thanks in advance, this will help me assess where my money's going.Excel Formula - I would like to calculate what percentage of my monthly income I spend on various expenses?
....A......B..........C

1..Rent...$1000 =(b1/b15)

2..Food...$500 = (b2/b15)

etc.



15 Total $5000Excel Formula - I would like to calculate what percentage of my monthly income I spend on various expenses?
Here's a great Excel template for your monthly budget: http://office.microsoft.com/en-us/templa鈥?/a>



For more Office resources head to http://www.facebook.com/office



Cheers,

Andy

MSFT Office Outreach Team