Credit card Calculation
Sorry! That should have been
=MAX(ROUND(L4*L8,2),L10)
"Stephen" <none wrote in message
...
Try this:
=MIN(ROUND(L4*L8,2),L10)
"Joel" wrote in message
...
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
|