FUNCTIONS

g DATA BASE FUNCTIONS

4 DAVERAGE : Returns the average of selected database entries
4 DCOUNT : Counts the cells that contain numbers in a database
4 DCOUNTA : Counts nonblank cells in a database
4 DGET : Extracts from a database a single record that matches the specified criteria
4 DMAX : Returns the maximum value from selected database entries
4 DMIN : Returns the minimum value from selected database entries
4 DPRODUCT : Multiplies the values in a particular field of records that match the criteria in a database
4 DSTDEV : Estimates the standard deviation based on a sample of selected database entries
4 DSTDEVP : Calculates the standard deviation based on the entire population of selected database entries
4 DSUM : Adds the numbers in the field column of records in the database that match the criteria
4 DVAR : Estimates variance based on a sample from selected database entries
4 DVARP : Calculates variance based on the entire population of selected database entries


g DATE AND TIME FUNCTIONS

4 DATE : Returns the serial number of a particular date
4 DATEVALUE : Converts a date in the form of text to a serial number
4 DAY : Converts a serial number to a day of the month
4 DAYS360 : Calculates the number of days between two dates based on a 360-day year
4 EDATE : Returns the serial number of the date that is the indicated number of months before or after the start date
4 EOMONTH : Returns the serial number of the last day of the month before or after a specified number of months
4 HOUR : Converts a serial number to an hour
4 MINUTE : Converts a serial number to a minute
4 MONTH : Converts a serial number to a month
4 NETWORKDAYS : Returns the number of whole workdays between two dates
4 NOW : Returns the serial number of the current date and time
4 SECOND : Converts a serial number to a second
4 TIME : Returns the serial number of a particular time
4 TIMEVALUE : Converts a time in the form of text to a serial number
4 TODAY : Returns the serial number of today's date
4 WEEKDAY : Converts a serial number to a day of the week
4 WEEKNUM : Converts a serial number to a number representing where the week falls numerically with a year
4 WORKDAY : Returns the serial number of the date before or after a specified number of workdays
4 YEAR : Converts a serial number to a year
4 YEARFRAC : Returns the year fraction representing the number of whole days between start_date and end_date


g ENGINEERING FUNCTION

4 BESSELI : Returns the modified Bessel function In(x)
4 BESSELJ : Returns the Bessel function Jn(x)
4 BESSELK : Returns the modified Bessel function Kn(x)
4 BESSELY : Returns the Bessel function Yn(x)
4 BIN2DEC : Converts a binary number to decimal
4 BIN2HEX : Converts a binary number to hexadecimal
4 BIN2OCT : Converts a binary number to octal
4 COMPLEX : Converts real and imaginary coefficients into a complex number
4 CONVERT : Converts a number from one measurement system to another
4 DEC2BIN : Converts a decimal number to binary
4 DEC2HEX : Converts a decimal number to hexadecimal
4 DEC2OCT : Converts a decimal number to octal
4 DELTA : Tests whether two values are equal
4 ERF : Returns the error function
4 ERFC : Returns the complementary error function
4 GESTEP : Tests whether a number is greater than a threshold value
4 HEX2BIN : Converts a hexadecimal number to binary
4 HEX2DEC : Converts a hexadecimal number to decimal
4 HEX2OCT : Converts a hexadecimal number to octal
4 IMABS : Returns the absolute value (modulus) of a complex number
4 IMAGINARY : Returns the imaginary coefficient of a complex number
4 IMARGUMENT : Returns the argument theta, an angle expressed in radians
4 IMCONJUGATE : Returns the complex conjugate of a complex number
4 IMCOS : Returns the cosine of a complex number
4 IMDIV : Returns the quotient of two complex numbers
4 IMEXP : Returns the exponential of a complex number
4 IMLN : Returns the natural logarithm of a complex number
4 IMLOG10 : Returns the base-10 logarithm of a complex number
4 IMLOG2 : Returns the base-2 logarithm of a complex number
4 IMPOWER : Returns a complex number raised to an integer power
4 IMPRODUCT : Returns the product of from 2 to 29 complex numbers
4 IMREAL : Returns the real coefficient of a complex number
4 IMSIN : Returns the sine of a complex number
4 IMSQRT : Returns the square root of a complex number
4 IMSUB : Returns the difference between two complex numbers
4 IMSUM : Returns the sum of complex numbers
4 OCT2BIN : Converts an octal number to binary
4 OCT2DEC : Converts an octal number to decimal
4 OCT2HEX : Converts an octal number to hexadecimal




4 ACCRINT : Returns the accrued interest for a security that pays periodic interest
4 ACCRINTM : Returns the accrued interest for a security that pays interest at maturity
4 AMORDEGRC : Returns the depreciation for each accounting period by using a depreciation coefficient
4 AMORLINC : Returns the depreciation for each accounting period
4 COUPDAYBS : Returns the number of days from the beginning of the coupon period to the settlement date
4 COUPDAYS : Returns the number of days in the coupon period that contains the settlement date
4 COUPDAYSNC : Returns the number of days from the settlement date to the next coupon date
4 COUPNCD : Returns the next coupon date after the settlement date
4 COUPNUM : Returns the number of coupons payable between the settlement date and maturity date
4 COUPPCD : Returns the previous coupon date before the settlement date
4 CUMIPMT : Returns the cumulative interest paid between two periods
4 CUMPRINC : Returns the cumulative principal paid on a loan between two periods
4 DB : Returns the depreciation of an asset for a specified period by using the fixed-declining balance method
4 DDB : Returns the depreciation of an asset for a specified period by using the double-declining balance method
4 DDB : ..... or some other method that you specify
4 DISC : Returns the discount rate for a security
4 DOLLARDE : Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
4 DOLLARFR : Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
4 DURATION : Returns the annual duration of a security with periodic interest payments
4 EFFECT : Returns the effective annual interest rate
4 FV : Returns the future value of an investment
4 FVSCHEDULE : Returns the future value of an initial principal after applying a series of compound interest rates
4 INTRATE : Returns the interest rate for a fully invested security
4 IPMT : Returns the interest payment for an investment for a given period
4 IRR : Returns the internal rate of return for a series of cash flows
4 ISPMT : Calculates the interest paid during a specific period of an investment
4 MDURATION : Returns the Macauley modified duration for a security with an assumed par value of $100
4 MIRR : Returns the internal rate of return where positive and negative cash flows are financed at different rates
4 NOMINAL : Returns the annual nominal interest rate
4 NPER : Returns the number of periods for an investment
4 NPV : Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
4 ODDFPRICE : Returns the price per $100 face value of a security with an odd first period
4 ODDFYIELD : Returns the yield of a security with an odd first period
4 ODDLPRICE : Returns the price per $100 face value of a security with an odd last period
4 ODDLYIELD : Returns the yield of a security with an odd last period
4 PMT : Returns the periodic payment for an annuity
4 PPMT : Returns the payment on the principal for an investment for a given period
4 PRICE : Returns the price per $100 face value of a security that pays periodic interest
4 PRICEDISC : Returns the price per $100 face value of a discounted security
4 PRICEMAT : Returns the price per $100 face value of a security that pays interest at maturity
4 PV Returns : the present value of an investment
4 RATE : Returns the interest rate per period of an annuity
4 RECEIVED : Returns the amount received at maturity for a fully invested security
4 SLN : Returns the straight-line depreciation of an asset for one period
4 SYD : Returns the sum-of-years' digits depreciation of an asset for a specified period
4 TBILLEQ : Returns the bond-equivalent yield for a Treasury bill
4 TBILLPRICE : Returns the price per $100 face value for a Treasury bill
4 TBILLYIELD : Returns the yield for a Treasury bill
4 VDB : Returns the depreciation of an asset for a specified or partial period by using a declining balance method
4 XIRR : Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
4 XNPV : Returns the net present value for a schedule of cash flows that is not necessarily periodic
4 YIELD : Returns the yield on a security that pays periodic interest
4 YIELDDISC : Returns the annual yield for a discounted security; for example, a Treasury bill
4 YIELDMAT : Returns the annual yield of a security that pays interest at maturity