Dear Experts
My data in 150 Sheets its a Account Data for 150 customers.

In column C i have amount after Due Data which is in Column B.And In Column
F i have a Amount Which is Paid by Customers.

First i want to Calculate the Extra Interest In Column G @5% Depending on
the numbers of Due Days (Column D) after the Due Dates i.e. is in (Column B)

Secondly If the Customer is Paid the Less Amount (Column F)of his Due Date
Amount (Column C), Then Calculate the Extra Interest in (Column J) @5% On Per
Month.

But If Customer is not Clearing his Dr. ( Column H) in Second or Third Month
then Calculate the Extra Interest in (Column I)

For Example: Say Customer will Not Clearing his Dr.( Column H) for 3 Months
As Example in H2,H2,H4

Then Calculate the Extra Interest for First month in J2 @ 5% for 3Months. In
J3 @5% for 2Months.In J4 @5% for 1Months
And so no.



Sheet2

A B C D E F G H I J
1 S.No Due Date Amount Due Days Date Received Paid Amount Interest @5% DR.
Total of DR. Charges @5% ON Dr
2 1 28-Feb-06 6292 2 2-Mar-06 6166 126 126
3 2 28-Mar-06 6292 5 6-Apr-06 6000 292 418
4 3 28-Apr-06 6292 6 4-May-06 6000 292 584
5 4 28-May-06 6292 4 30-Jun-06 7000 -708 -416
6 5 28-Jun-06 6292 15 1-Jul-06 6166 126 -582

Spreadsheet Formulas
Cell Formula
H2 =+C2-F2
I2 =+H2
H3 =+C3-F3
I3 =+H2+H3
H4 =+C4-F4
I4 =+H3+H4
H5 =+C5-F5
I5 =+H4+H5
H6 =+C6-F6
I6 =+H5+H6

Actually In column H is a DR. on Customers and Customer Will Pay this Late
Fees Charges With Interest Rate @5%.

For ex: In H2=126,H3=292,H4=292

See (Column I) Then Charge the Late Fee Charges@5% in Column J

Means if Customer is not Clearing his DR. then he have to paid Interest on
his Amount.

Any Help Will be most Appreciate