Re: Need help building a simple worksheet, please

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: tsides (tsides_at_intelligentsystemsconsulting.com)
Date: 05/10/04 

Date: 10 May 2004 06:56:14 -0700

In other words:

If you put the extra $ you have in cell A1, and then you put start
your columns in column B, you would format your spreadsheet like this

Extra Owed Amount % of Debt Amount to Pay Them
$100 Bob 100
         Jim 60
         Bill 15
         Total

In order to calculate the total, use the formula =SUM(C2:C4). Type
the =SUM( and then use your mouse to highlight the cells containing
the amounts you owe.

In the "% of Debt" column, on Bob's row, use the formula =C2/C$5.
Copy that formula down for Jim, Bill, etc. Format the entire column as
a percent.

in the "Amount to Pay Them" column, on Bob's row, use the formula
=A$2*D2. Copy that formula down for Jim, Bill, etc.

By the way, this sounds like a good way to pay back debts, but not a
good way to pay back credit cards. Credit cards all have different
interest rates, and I would recommend paying minimum balance on all
credit cards. Then, take all extra money and send it to the one
credit card balance that is costing you the highest interest rate.
But then again, if I were you, I'd take input frmo me on Excel, but
not on finances.

Relevant Pages

  • Re: debt
    ... >You mean those people who use credit cards and don't pay off the full ... >amount each month, surely? ... Prev by Date: ...
    (uk.finance)
  • Re: zend studio trial version cd
    ... studio IDE.If anyone having this great studio.plz send cd format. ... will pay for postal,cd and ur affort.plz send ur amount and details ...
    (comp.lang.php)
  • RE: Tracking Time (Hours/Mins)
    ... if it is pay per minute ... format as curremyc, number or general or else you'll get the amount in time ... > produce a dollar amount, so the unit result should probably be minutes, as ...
    (microsoft.public.excel.misc)
  • Re: Credit card in Singapore charging Annual Fee
    ... The annual fee may be a small amount, ... wants to pay them? ... there is no annual fee for using credit cards in the USA. ...
    (soc.culture.singapore)
  • Re: Collections and The Nursing Home Dilemma - please assist, please? OP update
    ... perhaps pay off the bills with that and maybe a little help from me ... >A power of attorney does not make you liable for your grandmother's debts. ... >answering machine and pay them off when you are able. ... >refinance the house to pay off the credit cards. ...
    (misc.legal)