Friday 20 January 2017

How to Create Simple Intrest in Excel

SIMPLE INTEREST ఎలా చెయ్యాలి ఎక్సెల్ లో. 














steps 
1. Create a Table above shown.
2. Type your Formula at b5 (ie: =(b2*b3*b4)/12 
(note: b2 means Loan Amount, b3 means rate of interest, b4 means Time)
 3. Now Press 'Enter' 
4. It Will Show the Total interest for 12 Months.


No comments:

Post a Comment