CA AYUSH AGRAWAL (Kolkata-Pune-Mumbai) (26986 Points)
29 October 2012To 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.
O G
(PN)
(40 Points)
Replied 31 October 2012
I did not understand a few thing there, tho I have tried, you just have to put formula for calculating interest
Hope it helps
CA AYUSH AGRAWAL
(Kolkata-Pune-Mumbai)
(26986 Points)
Replied 01 November 2012
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.
Live class on PF & ESI Enrollment & Returns Filing(with recording)
CAclubindia
