# formula changes help

#### ehsas

##### Board Regular
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

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
ANY ONE COULD HELP PLEASE.Regards

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.

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?

pll

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

No this is not similar problem.Regards,

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. "

Replies
6
Views
739
Replies
8
Views
299
Replies
1
Views
477
Replies
1
Views
318
Replies
6
Views
941

1,218,920
Messages
6,145,218
Members
450,602
Latest member
AceSpace

### 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?

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