formula changes help

ehsas

Board Regular
Joined
Sep 17, 2002
Messages
200
OVERDUEINT02980388660011.xls
ABCDEFGH
2INT0.05%
3AMT1583
4dateduedateduedateintperdaytotalint
525-Jun-99#N/A#N/A#N/A25-May-99321.5386761.5387
625-Mar-00#N/A#N/A#N/A25-Feb-00300.7693382.3080
Sheet2


Looking into above excel file I need help in calculating the interest due.The due date is 25 of each month
looking into date between e5 and a5 the a/c is due for two month and also looking the date between e6 and a6 a/c is also due for two month but the problem is because the interest is calculating on due date which is number of days(f5 and f6) the interest is differ where it needs to be exact.for f5 it calculating at to months where for f6 it calculating for one month.Please into the formula in g5 and g6 for same.Could any please help where i can calculate same based on number of months on due date.Regards,
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
Could you try to explain your problem a little more clearly. Please give a detailed breakdown of the calculation you need, including an indication of the expected result.

Paddy
 

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS

ADVERTISEMENT

In addition what PaddyD asks, might you also explain the basis for "0,32,62" in cell G6 (......MATCH(F6,{0,32,62}.....).

In general it seems you have doubled up on the calculation some where....are there some ranges that are being used that are critical to the calculation that don't show up on your short presentation?

A little more info would be helpful...

pll
 

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS

ADVERTISEMENT

It does look like a continuation of that problem...but the latest issue does not seem to indicate a late fee implication as the first proiblem did.....seems like only an interest calc on a principal amount on the second problem.....

I guess we await the authors feedback.


pll
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
In which case,

" Could you try to explain your problem a little more clearly. Please give a detailed breakdown of the calculation you need, including an indication of the expected result. "

Paddy
 

Forum statistics

Threads
1,143,915
Messages
5,721,506
Members
422,369
Latest member
redinator

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top