Credit Card....

[Jenniphur]

I'm making a spreadsheet of credit cards and bills taken out of my
monthly check. Well what I want is everytime I type in that I made a
payment on my credit card, I want it to be taken out of my balance...
but I want it to be accurate with my statement so I'll have to do
something to calculate the interest.... I have NO idea what any
formulas are.... Can you tell me how to do this without completely
confusing me?! haha thanks!

 

[Bill Sharpe]

I'm making a spreadsheet of credit cards and bills taken out of my
monthly check. Well what I want is everytime I type in that I made a
payment on my credit card, I want it to be taken out of my balance...
but I want it to be accurate with my statement so I'll have to do
something to calculate the interest.... I have NO idea what any
formulas are.... Can you tell me how to do this without completely
confusing me?! haha thanks!

Consider buying Quicken or MS Money, which are written especially for
financial calculations like these.

Also consider paying off your credit card bills in full each month so
that htere is no interest to be concerned with.

Bill