Hi
Attachment is missing..
Thx
On Mon, Apr 28, 2014 at 7:14 PM, L.K. Modi wrote:
> Dear Sir
>
> I have downloaded a file from the net but unable to understand the logic
> in column Q AND R as the file is read only only so can anyone say me how
> that delay had been calculated and interest is
Hi Modi,
Im not clear with Defaults month (column Q) because it does not match with
due date and payment day.
But Defaults Interest (column R) is calculate by if *defaults
months*greater than 0 then *TDS
amount * 1.5% * defaults months* else the defaults interest will be *0*.
(=if(defaultsmonth>0
Dear Sir
I have downloaded a file from the net but unable to understand the logic in
column Q AND R as the file is read only only so can anyone say me how that
delay had been calculated and interest is calculated...
thanks in advance
regards
LKM
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exc
