Working with Percents

[kjvliferider]

Hi all,

i'm trying to organize my money savings and spendings. I would like to make a list of every place that my money goes (car repair,vacation,savings,ect..) and add a percent to each cell, so when I add my paycheck total every week I can watch each catagory grow and know exactly how much i have to spend on gas, christmas, ect....

I found the formula for sums and it works great but I was unable to understand or find the percent formula that I was looking for.

Thank You in advance for any suggestions.

Also, I was wondering if this could be used on the excel app?

[Fotis1991]

Assuming your number are from B1 to b9. B10 is the sum of these numbers.

In c1 and copy down to c9, put this formula and format the cells as %.

=B1/$B$10

[kjvliferider]

Okay and then where would I add my, paycheck amount?

[Fotis1991]

.......................

[kjvliferider]

Thats pretty much what I am trying to do. But I was unable to get excel to find the percents for me. Is there a way I can put 498 into a cell and have excel divide it amoung those 9 different percents?