Whew! This question needs work, Hardeep_kanwar. I can't tell what a "Dr."
is - not a doctor, I take it. I don't know what you mean by "extra" interest
in columns G, I and J; why not just interest? And I don't know what a "less
amount" is (re col F). Can you find a way to say less about this problem and
explain more? Maybe just tackle one small piece of the problem at a time?

--- "Hardeep_kanwar" wrote:
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.