July 2, 200124 yr WHY ARE YOU SHOUTING? You'll need to refresh our memory on exactly the structure of your file an what you wish the calculation to accomplish. Also throw in the calculation you are currently using. -bd
July 3, 200124 yr I RECENTLY SUBMITTED A QUESTION REGARDING CALCULATION OF FINANCE CHARGES... HOWEVER I HAVE SEVERAL INVOICES GOING OUT TO A YEAR. STATE LAW PROHIBITS FINANCE CHARGES TO GO PAST ONE YEAR. WHAT WOULD BE THE CALCULATION TO SCALE THE ADDITIONAL FINANCE CHARGE EACH THIRTY DAYS 30,60,90,120,150,180,210,240,270,300,330, AND 360. I ORIGINALY THOUGHT AN IF WITHIN AN IF, AND SO ON, IT DOESN'T SEEM TO WORK OUT. ANY HELP WOULD BE APPRECIATED.
July 7, 200124 yr Given: IntRate = monthly interest rate in percent InvDate = Date of invoice InvCharge = Amount of original invoice Then the compound interest charge will be: ((IntRate/100+1)^Min(Int((Status(CurrentDate)-InvDate)/30),12)-1)*InvCharge
Create an account or sign in to comment