Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
EDATE(start_date,months) [Category: Date & Time]*
Returns the serial number that represents the date that is the indicated number of
months before or after a specifi ed date (the start_date). Use EDATE to calculate
maturity dates or due dates that fall on the same day of the month as the date
of issue. See page 51
EFFECT(nominal_rate,npery) [Category: Financial]*
Returns the effective annual interest rate, given the nominal annual interest rate
and the number of compounding periods per year.
EOMONTH(start_date,months) [Category: Date & Time]*
Returns the serial number for the last day of the month that is the indicated
number of months before or after start_date. Use EOMONTH to calculate
maturity dates or due dates that fall on the last day of the month. Guru Tip:
=EOMONTH(TODAY(),1) will return the last date of this month. This is a function
which returns the correct result in the wrong format. Always format the cell as
a date.
ERF(lower_limit,upper_limit) [Category: Engineering]*
Returns the error function integrated between lower_limit and upper_limit.
ERFC(x) [Category: Engineering]*
Returns the complementary ERF function integrated between x and infi nity.
ERROR.TYPE(error_val) [Category: Information]*
Returns a number corresponding to one of the error values in Microsoft Excel
or returns the #N/A error if no error exists. You can use ERROR.TYPE in an IF
function to test for an error value and return a text string, such as a message,
instead of the error value. Guru Tip: Here are the 7 types of errors and the result
from ERROR.TYPE:
 
Search JabSto ::




Custom Search