excell

Monday, 29 September 2014

INSERT RS

HOW TO INSERT  RS?

           EASY STAPE TO WRITE DOWN RS AS FOLLOWING
         
                                      FORMAT---CELLS--CUSTOM--"RS",###,###,##0.00 THEN OK

per month saving formula

Saving account=500000

Annual interest rate=10%

Number of years=18month

Per month saving=?

So,my formula is that,how to insert per month saving formula.

=pmt(annual interest rate/12,number of year*12,0,-saving amount) then enter