Calculation of Credit Card %
in [General]
|
From: Trainee on 4 Apr 2010 09:37 Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE CHARGES on XL? TX.
From: Niek Otten on 4 Apr 2010 10:23 What do you want to know? -- Kind regards, Niek Otten Microsoft MVP - Excel "Trainee" <Trainee(a)discussions.microsoft.com> wrote in message news:F246DE4B-EE72-4015-8D50-B4ADCA3E6BCC(a)microsoft.com... > Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE > CHARGES on XL? > TX.
From: Russell Dawson on 4 Apr 2010 10:27 If A1 contains 1500.00 and B1 the 12.99 in C1 input =A1*B1% -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Trainee" wrote: > Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE > CHARGES on XL? > TX.
From: Trainee on 4 Apr 2010 10:32 I guess this is the formula I'm looking for, probably just need to divide it for 12(months) to get the monthly FINANCE CHARGES IN C1 "Russell Dawson" wrote: > If A1 contains 1500.00 and B1 the 12.99 in C1 input =A1*B1% > > -- > Russell Dawson > Excel Student > > Please hit "Yes" if this post was helpful. > > > "Trainee" wrote: > > > Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE > > CHARGES on XL? > > TX.
From: Trainee on 4 Apr 2010 10:33
The monthly finance charges in C1 "Niek Otten" wrote: > What do you want to know? > > -- > Kind regards, > > Niek Otten > Microsoft MVP - Excel > > "Trainee" <Trainee(a)discussions.microsoft.com> wrote in message > news:F246DE4B-EE72-4015-8D50-B4ADCA3E6BCC(a)microsoft.com... > > Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE > > CHARGES on XL? > > TX. > |