View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Credit card Calculation

Hi thans for your help

I left out a bit of information so here goes;

Hi

I was wondering if anyone could help me with a minimum payment calculation
on my spreadsheet for my Credit card

I have the following Cells

Credit Limit (L2) £3500

Credit Card Amount Owed (L4) £3200

Credit Card APR (L6) 17.9%

Minimum Amount (L8) 2%

And then I have a cell (L10) Minimum Payment and it is in this Cell I want it
to say what my minimum payment will be if you could help with this that would
be great

Regards Joel


--
N/A


"Aqib Rizvi" wrote:

Enter the following in cell L8 =round(L4*.02,2)

Aqib Rizvi