Question about Microsoft Office Standard for PC
What function does one use to calculate emi on excel
The function in Excel for calculating EMI is not EMI but PMT. It requires minimum three arguments. They are 1. Rate of interest (Rate), 2. Number of periods (Nper) and 3. Value of loan or present value (Pv) in that order, that is, PMT (Rate, Nper, Pv)
If you want to find EMI for 1 lakh at 10% annual interest for 10 years you enter the following in one of the cells:
= pmt(10%/12, 10*12, 100000)
Borrowed from http://www.hindu.com/pp/2004/02/28/stories/2004022800160500.htm
Posted on Nov 09, 2007
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Jun 21, 2016 | Wells Fargo Personal Loan
Jul 30, 2014 | Microsoft Excel 2010
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
Mar 02, 2011 | Texas Instruments TI-83 Plus Calculator
Jun 09, 2010 | Microsoft Office Professional 2007 Full...
Mar 29, 2009 | Texas Instruments TI-30XA Calculator
Aug 25, 2008 | Microsoft Office Professional 2007:...
683 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: