Percentage

[spedkyo]

Basically I am trying to set up a budget. I want to be able to see what percentage I owe on a credit card. I am sure this is an easy formula but I can not figure it out.

thanks

 

[jonashvid]

If you can max it to 10,000,- and you have spend 6,000,- then you have used (6000/10000)*100 = 60%.

Is this what you were looking for...?

 

[spedkyo]

I think so. So i would type it in like =(B25/1000)*100. and that should give me a percentage. Does that look right?

 

[jonashvid]

Yep it would be (What you have spent / the max limit) * 100

 

[spedkyo]

Thank you. Very simple but I just could not get it. Can you recommend a Book or two on a complete overview of how to use excel too?

 

[meldoc]

Hello

This is a must have!

http://www.mrexcel.com/store/index.php?l=product_detail&p=210

http://www.mrexcel.com/store/index.php?l=product_detail&p=214

Also See.

http://www.youtube.com/user/bjele123

http://www.youtube.com/user/ExcelIsFun