SOURCE: emi using 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
SOURCE: how to formulate log function with excel
Here try this link
http://support.microsoft.com/kb/214116
SOURCE: formula for Calculating the turn around time in excel
dpprash,
I guess you mean the number of weekdays (or working days) excluding Saturdays and Sundays. So start a spreadshhet and put the start date (01/01/2009) in A2 and the end date (31/12/2009?) in B2.
Then paste the formula below into C2:
=B2-A2-2*INT((B2-A2+WEEKDAY(A2,3))/7)-MAX(0,WEEKDAY(B2,3)-4
better-swiss
SOURCE: HOW TO CALCULATE PERCENTAGE IN MICROSOFT EXCEL?
Hi nastyguy3000;
To calculate a percentage in excel you simply take
amount/total = percentage in your cell
Example
A
B
Purchase price
Sales tax (in decimal form)
800
0.089
Formula
Description (Result)
=A2*B2
Multiplies 800 by 0.089 to find the amount of sales tax to pay ($71.20)
Have Fun
Mark
Don't forget to leave a rating.
SOURCE: need a formula to calculate length of service in excel
You could do a simple +NOW-START DATE
It would depend on the format of your start dates - i.e YY, DD/MM/YY as to the results you get.
Do want the results in years, months, days?
183 views
Usually answered in minutes!
×