- Excel Functions - Home
- Compatibility Functions
- Compatibility Functions
- BETADIST Function
- BETAINV Function
- BINOMDIST Function
- CEILING Function
- CHIDIST Function
- CHIINV Function
- CHITEST Function
- CONFIDENCE Function
- COVAR Function
- CRITBINOM Function
- EXPONDIST Function
- FDIST Function
- FINV Function
- FLOOR Function
- FTEST Function
- GAMMADIST Function
- GAMMAINV Function
- HYPGEOMDIST Function
- LOGINV Function
- LOGNORMDIST Function
- MODE Function
- NEGBINOMDIST Function
- NORMDIST Function
- NORMINV Function
- NORMSDIST Function
- NORMSINV Function
- PERCENTILE Function
- PERCENTRANK Function
- POISSON Function
- QUARTILE Function
- RANK Function
- STDEV Function
- STDEVP Function
- TDIST Function
- TINV Function
- TTEST Function
- VAR Function
- VARP Function
- WEIBULL Function
- ZTEST Function
- Logical Functions
- Logical Functions
- AND Function
- FALSE Function
- IF Function
- IFERROR Function
- IFNA Function
- IFS Function
- NOT Function
- OR Function
- SWITCH Function
- TRUE Function
- XOR Function
- Text Functions
- Text Functions
- ARRAYTOTEXT Function
- BAHTTEXT Function
- CHAR Function
- CLEAN Function
- CODE Function
- CONCAT Function
- CONCATENATE Function
- DBCS Function
- DOLLAR Function
- Exact Function
- FIND Function
- FINDB Function
- FIXED Function
- LEFT Function
- LEFTB Function
- LEN Function
- LENB Function
- LOWER Function
- MID Function
- MIDB Function
- NUMBERVALUE Function
- PHONETIC Function
- PROPER Function
- REPLACE Function
- REPLACEB Function
- REPT Function
- RIGHT Function
- RIGHTB Function
- SEARCH Function
- SEARCHB Function
- SUBSTITUTE Function
- T Function
- TEXT Function
- TEXTAFTER Function
- TEXTBEFORE Function
- TEXTJOIN Function
- TEXTSPLIT Function
- TRIM Function
- UNICHAR Function
- UNICODE Function
- UPPER Function
- VALUE Function
- VALUETOTEXT Function
- Date & Time Functions
- Date & Time Functions
- DATE Function
- DATEDIF Function
- DATEVALUE Function
- DAY Function
- DAYS Function
- DAYS360 Function
- EDATE Function
- EOMONTH Function
- HOUR Function
- ISOWEEKNUM Function
- MINUTE Function
- MONTH Function
- NETWORKDAYS Function
- NETWORKDAYS.INTL Function
- NOW Function
- SECOND Function
- TIME Function
- TIMEVALUE Function
- TODAY Function
- WEEKDAY Function
- WEEKNUM Function
- WORKDAY Function
- WORKDAY.INTL Function
- YEAR Function
- YEARFRAC Function
- Cube Functions
- Cube Functions
- CUBEKPIMEMBER Function
- CUBEMEMBER Function
- CUBEMEMBERPROPERTY Function
- CUBERANKEDMEMBER Function
- CUBESET Function
- CUBESETCOUNT Function
- CUBEVALUE Function
- Math Functions
- Math Functions
- ABS Function
- AGGREGATE Function
- ARABIC Function
- BASE Function
- CEILING.MATH Function
- COMBIN Function
- COMBINA Function
- DECIMAL Function
- DEGREES Function
- EVEN Function
- EXP Function
- FACT Function
- FACTDOUBLE Function
- FLOOR.MATH Function
- GCD Function
- INT Function
- LCM Function
- LN Function
- LOG Function
- LOG10 Function
- MDETERM Function
- MINVERSE Function
- MMULT Function
- MOD Function
- MROUND Function
- MULTINOMIAL Function
- MUNIT Function
- ODD Function
- PI Function
- POWER Function
- PRODUCT Function
- QUOTIENT Function
- RADIANS Function
- RAND Function
- RANDBETWEEN Function
- ROMAN Function
- ROUND Function
- ROUNDDOWN Function
- ROUNDUP Function
- SERIESSUM Function
- SIGN Function
- SQRT Function
- SQRTPI Function
- SUBTOTAL Function
- SUM Function
- SUMIF Function
- SUMIFS Function
- SUMPRODUCT Function
- SUMSQ Function
- SUMX2MY2 Function
- SUMX2PY2 Function
- SUMXMY2 Function
- TRUNC Function
- Trigonometric Functions
- Trigonometric Functions
- ACOS
- ACOSH Function
- ACOT Function
- ACOTH Function
- ASIN Function
- ASINH Function
- ATAN Function
- ATAN2 Function
- ATANH Function
- COS Function
- COSH Function
- COT Function
- COTH Function
- CSC Function
- CSCH Function
- SEC Function
- SECH Function
- SIN Function
- SINH Function
- TAN Function
- TANH Function
- Database Functions
- Database Functions
- DAVERAGE
- DCOUNT
- DCOUNTA
- DGET
- DMAX
- DMIN
- DPRODUCT
- DSTDEV
- DSTDEVP
- DSUM
- DVAR
- DVARP
- Dynamic Array Functions
- Dynamic Array Functions
- FILTER Function
- RANDARRAY Function
- SEQUENCE Function
- SORT Function
- SORTBY Function
- UNIQUE Function
- XLOOKUP Function
- XMATCH Function
- Engineering Functions
- Engineering Functions
- BESSELI Function
- BESSELJ Function
- BESSELK Function
- BESSELY Function
- BIN2DEC Function
- BIN2HEX Function
- BIN2OCT Function
- BITAND Function
- BITLSHIFT Function
- BITOR Function
- BITRSHIFT Function
- BITXOR Function
- COMPLEX Function
- CONVERT Function
- DEC2BIN Function
- DEC2HEX Function
- DEC2OCT Function
- DELTA Function
- ERF Function
- ERF.PRECISE Function
- ERFC Function
- ERFC.PRECISE Function
- GESTEP Function
- HEX2BIN Function
- HEX2DEC Function
- HEX2OCT Function
- IMABS Function
- IMAGINARY Function
- IMARGUMENT Function
- IMCONJUGATE Function
- IMCOS Function
- IMCOSH Function
- IMCOT Function
- IMCSC Function
- IMCSCH Function
- IMDIV Function
- IMEXP Function
- IMLN Function
- IMLOG2 Function
- IMLOG10 Function
- IMPOWER Function
- IMPRODUCT Function
- IMREAL Function
- IMSEC Function
- IMSECH Function
- IMSIN Function
- IMSINH Function
- IMSQRT Function
- IMSUB Function
- IMSUM Function
- IMTAN Function
- OCT2BIN Function
- OCT2DEC Function
- OCT2HEX Function
- Financial Functions
- Financial Functions
- ACCRINT Function
- ACCRINTM Function
- AMORDEGRC Function
- AMORLINC Function
- COUPDAYBS Function
- COUPDAYS Function
- COUPDAYSNC Function
- COUPNCD Function
- COUPNUM Function
- COUPPCD Function
- CUMIPMT Function
- CUMPRINC Function
- DB Function
- DDB Function
- DISC Function
- DOLLARDE Function
- DOLLARFR Function
- DURATION Function
- EFFECT Function
- FV Function
- FVSCHEDULE Function
- INTRATE Function
- IPMT Function
- IRR Function
- ISPMT Function
- MDURATION Function
- MIRR Function
- NOMINAL Function
- NPER Function
- NPV Function
- ODDFPRICE Function
- ODDFYIELD Function
- ODDLPRICE Function
- ODDLYIELD Function
- PDURATION Function
- PMT Function
- PPMT Function
- PRICE Function
- PRICEDISC Function
- PRICEMAT Function
- PV Function
- RATE Function
- RECEIVED Function
- RRI Function
- SLN Function
- SYD Function
- TBILLEQ Function
- TBILLPRICE Function
- TBILLYIELD Function
- VDB Function
- XIRR Function
- XNPV Function
- YIELD Function
- YIELDDISC Function
- YIELDMAT Function
- Information Functions
- Information Functions
- CELL Function
- ERROR.TYPE Function
- INFO Function
- ISBLANK Function
- ISERR Function
- ISERROR Function
- ISEVEN Function
- ISFORMULA Function
- ISLOGICAL Function
- ISNA Function
- ISNONTEXT Function
- ISNUMBER Function
- ISODD Function
- ISREF Function
- ISTEXT Function
- N Function
- NA Function
- SHEET Function
- SHEETS Function
- TYPE Function
- Lookup & Reference Functions
- Lookup & Reference Functions
- ADDRESS Function
- AREAS Function
- CHOOSE Function
- COLUMN Function
- COLUMNS Function
- FORMULATEXT Function
- GETPIVOTDATA Function
- HLOOKUP Function
- HYPERLINK Function
- INDEX Function
- INDIRECT Function
- LOOKUP Function
- MATCH Function
- OFFSET Function
- ROW Function
- ROWS Function
- RTD Function
- TRANSPOSE Function
- VLOOKUP Function
- Statistical Functions
- Statistical Functions
- AVEDEV Function
- AVERAGE Function
- AVERAGEA Function
- AVERAGEIF Function
- AVERAGEIFS Function
- BETA.DIST Function
- BETA.INV Function
- BINOM.DIST Function
- BINOM.DIST.RANGE Function
- BINOM.INV Function
- CHISQ.DIST Function
- CHISQ.DIST.RT Function
- CHISQ.INV Function
- CHISQ.INV.RT Function
- CHISQ.TEST Function
- CONFIDENCE.NORM Function
- CONFIDENCE.T Function
- CORREL Function
- COUNT Function
- COUNTA Function
- COUNTBLANK Function
- COUNTIF Function
- COUNTIFS Function
- COVARIANCE.P Function
- COVARIANCE.S Function
- DEVSQ Function
- EXPON.DIST Function
- F.DIST Function
- F.DIST.RT Function
- F.INV Function
- F.INV.RT Function
- F.TEST Function
- FISHER Function
- FISHERINV Function
- FORECAST Function
- FORECAST.ETS Function
- FORECAST.ETS.CONFINT Function
- FORECAST.ETS.SEASONALITY Function
- FORECAST.ETS.STAT Function
- FORECAST.LINEAR Function
- FREQUENCY Function
- GAMMA Function
- GAMMA.DIST Function
- GAMMA.INV Function
- GAMMALN Function
- GAMMALN.PRECISE Function
- GAUSS Function
- GEOMEAN
- GROWTH
- HARMEAN
- HYPGEOM.DIST
- INTERCEPT Function
- KURT Function
- LARGE Function
- LINEST Function
- LOGEST Function
- LOGNORM.DIST Function
- LOGNORM.INV Function
- MAX Function
- MAXA Function
- MAXIFS Function
- MEDIAN Function
- MIN Function
- MINA Function
- MINIFS Function
- MODE.MULT Function
- MODE.SNGL Function
- NEGBINOM.DIST Function
- NORM.DIST Function
- NORM.INV Function
- NORM.S.DIST Function
- NORM.S.INV Function
- PEARSON Function
- PERCENTILE.EXC
- PERCENTILE.INC
- PERCENTRANK.EXC
- PERCENTRANK.INC
- PERMUT
- PERMUTATIONA
- PHI
- POISSON.DIST
- PROB
- QUARTILE.EXC
- QUARTILE.INC
- RANK.AVG
- RANK.EQ
- RSQ
- SKEW
- SKEW.P
- SLOPE
- SMALL
- STANDARDIZE
- STDEV.P
- STDEV.S
- STDEVA
- STDEVPA
- STEYX
- T.DIST
- T.DIST.2T
- T.DIST.RT
- T.INV
- T.INV.2T
- T.TEST
- TREND
- TRIMMEAN Function
- VAR.P Function
- VAR.S Function
- VARA Function
- VARPA Function
- WEIBULL.DIST Function
- Z.TEST Function
- Web Functions
- Web Functions
- ENCODEURL Function
- FILTERXML Function
- WEBSERVICE Function
Excel - Financial Functions
Excel Financial functions perform many of the common financial calculations, such as the calculation of yield, interest rates, duration, valuation and asset depreciation.
| S.No. | Function and Description |
|---|---|
| 1 | ACCRINT
Returns the accrued interest for a security that pays periodic interest |
| 2 | ACCRINTM
Returns the accrued interest for a security that pays interest at maturity |
| 3 | AMORDEGRC
Returns the depreciation for each accounting period |
| 4 | AMORLINC
Returns the depreciation for each accounting period (the depreciation coefficient depends on the life of the assets) |
| 5 | COUPDAYBS
Returns the number of days from the beginning of the coupon period to the settlement date |
| 6 | COUPDAYS
Returns the number of days in the coupon period that contains the settlement date |
| 7 | COUPDAYSNC
Returns the number of days from the settlement date to the next coupon date |
| 8 | COUPNCD
Returns the next coupon date after the settlement date |
| 9 | COUPNUM
Returns the number of coupons payable between the settlement date and maturity date |
| 10 | COUPPCD
Returns the previous coupon date before the settlement date |
| 11 | CUMIPMT
Returns the cumulative interest paid between two periods |
| 12 | CUMPRINC
Returns the cumulative principal paid on a loan between two periods |
| 13 | DB
Returns the depreciation of an asset for a specified period, using the fixed-declining-balance method |
| 14 | DDB
Returns the depreciation of an asset for a specified period, using the double-declining-balance method or some other method that you specify |
| 15 | DISC
Returns the discount rate for a security |
| 16 | DOLLARDE
Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number |
| 17 | DOLLARFR
Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction |
| 18 | DURATION
Returns the annual duration of a security with periodic interest payments |
| 19 | EFFECT
Returns the effective annual interest rate |
| 20 | FV
Returns the future value of an investment |
| 21 | FVSCHEDULE
Returns the future value of an initial principal after applying a series of compound interest rates |
| 22 | INTRATE
Returns the interest rate for a fully invested security |
| 23 | IPMT
Returns the interest payment for an investment for a given period |
| 24 | IRR
Returns the internal rate of return for a series of cash flows |
| 25 | ISPMT
Calculates the interest paid during a specific period of an investment |
| 26 | MDURATION
Returns the Macauley modified duration for a security with an assumed par value of $100 |
| 27 | MIRR
Returns the internal rate of return where positive and negative cash flows are financed at different rates |
| 28 | NOMINAL
Returns the annual nominal interest rate |
| 29 | NPER
Returns the number of periods for an investment |
| 30 | NPV
Returns the net present value of an investment based on a series of periodic cash flows and a discount rate |
| 31 | ODDFPRICE
Returns the price per $100 face value of a security with an odd first period |
| 32 | ODDFYIELD
Returns the yield of a security with an odd first period |
| 33 | ODDLPRICE
Returns the price per $100 face value of a security with an odd last period |
| 34 | ODDLYIELD
Returns the yield of a security with an odd last period |
| 35 | PDURATION
Returns the number of periods required by an investment to reach a specified value |
| 36 | PMT
Returns the periodic payment for an annuity |
| 37 | PPMT
Returns the payment on the principal for an investment for a given period |
| 38 | PRICE
Returns the price per $100 face value of a security that pays periodic interest |
| 39 | PRICEDISC
Returns the price per $100 face value of a discounted security |
| 40 | PRICEMAT
Returns the price per $100 face value of a security that pays interest at maturity |
| 41 | PV
Returns the present value of an investment |
| 42 | RATE
Returns the interest rate per period of an annuity |
| 43 | RECEIVED
Returns the amount received at maturity for a fully invested security |
| 44 | RRI
Returns an equivalent interest rate for the growth of an investment |
| 45 | SLN
Returns the straight-line depreciation of an asset for one period |
| 46 | SYD
Returns the sum-of-years digits depreciation of an asset for a specified period |
| 47 | TBILLEQ
Returns the bond-equivalent yield for a Treasury bill |
| 48 | TBILLPRICE
Returns the price per $100 face value for a Treasury bill |
| 49 | TBILLYIELD
Returns the yield for a Treasury bill |
| 50 | VDB
Returns the depreciation of an asset for a specified or partial period using a declining-balance method |
| 51 | XIRR
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic |
| 52 | XNPV
Returns the net present value for a schedule of cash flows that is not necessarily periodic |
| 53 | YIELD
Returns the yield on a security that pays periodic interest |
| 54 | YIELDDISC
Returns the annual yield for a discounted security, for example, a Treasury bill |
| 55 | YIELDMAT
Returns the annual yield of a security that pays interest at maturity |