To All Dear Excel Experts,
I am Attaching Here One File, in That Interest is to be Calculated.
Well, Put The Best Formuls in Your Knowledge, so That Lesser labour is required.
While Calculating, Pls Keep in Mind That This is Just Example, , Data is Huge, Number of Invoice & Number of Part Payments.
Do Calculate at Your Best & Attach Here.
No One Solved Yet ???
I did not understand a few thing there, tho I have tried, you just have to put formula for calculating interest
Hope it helps
Dear OG,
You Have Just Put Formula,
You Have Considered Only Date of Payment Against Date of Invoice.
But Not Considered Payments Installments.
Because Here Payments Camed in Part Part.
so In This Case Interest is to be Calculated Accordingly.
CAclubindia
