You would calculate it using the Sum function. It will depend on what cells your values are in as to what form the actual formula will take.
cash a/c.......dr amt(after discount) to sales a/c amt(after discount)
The PPMT function returns the amt. of interest in a specified instalment number whereas the PMT function returns the amt. of interest in every EMI payment.
numbervar RmVal:=0; numbervar Amt:=0; numbervar pAmt:=0; stringvar InWords :="Rupees "; Amt := numeric value ; if Amt > 10000000 then RmVal := truncate(Amt/10000000); if Amt = 10000000 then RmVal := 1; if RmVal = 1 then InWords := InWords + " " + towords(RmVal,0) + " crore" else if RmVal > 1 then InWords := InWords + " " + towords(RmVal,0) + " crores"; Amt := Amt - Rmval * 10000000; if Amt > 100000 then RmVal := truncate(Amt/100000); if Amt = 100000 then RmVal := 1; if Amt 1 then InWords := InWords + " " + towords(RmVal,0) + " lakhs"; Amt := Amt - Rmval * 100000; if Amt > 0 then InWords := InWords + " " + towords(truncate(Amt),0); pAmt := (Amt - truncate(Amt)) * 100; if pAmt > 0 then InWords := InWords + " and " + towords(pAmt,0) + " paisa only" else InWords := InWords + " only"; UPPERCASE(InWords)
AMT is he advanced manufacturing technology
Amt 380 backup #70100
AMT stands for amount.
Arcadia Machine and Tool
Das Amt was created in 1997.
McMasterville - AMT - was created in 2000.
Chabanel - AMT - was created in 2007.
Arcadia Machine and Tool
AMT Coffee was created in 1992.