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