Hi

[#1]

HI,

I have customer ledger in excel where debit\credit is there, i want to calculate interest penelty for each delay payment made after due date. pls help with formula.

[#2]

What data do you have? Is it just values in a Excel sprea sheet?

[#3]

(Credit / Debit) - 1 as a percentage.

[martynlloyd]

You mean like:

LOAD

TransID,

Amount,

DueDate,

Interval(Today()-DueDate, 'D') as DaysOverDue

...

expression:  =Amount * DaysOverDue * vDailyRate

?

M.

[#5]

Expression1 = (Amount * DaysOverDue * vDailyRate) + Amount to get total outstanding amount including interest

Expression2 = (Expression1 / Amount) - 1 to get the total interest charged.

Regards,
Marius

[#6]

hi give me your email id so that i can send you my excel file with requirement