EXCEL FORMULA | How to apply Formula for installment payment
FORMULA :-
DOWN PAYMENT KA:- =C2*15%
BALANCE AMOUNT KA :- =C2-D2
INTREST AMOUNT KA :- =E2*9%
TOTAL AMOUNT KA :- =E2+F2
INSTALMENT AMOUNT KA :- =G2/5
TOAL INSTALMENT AMOUNT :- =SUM(I2:M2)
NET BALANCE AMOUNT :- =G2-N2
Post a Comment
Post a Comment