|
Financial functions |
توابع مالی |
|
|
|
|
Function |
Description |
|
ACCRINT |
Returns the accrued interest for a security that pays periodic interest |
|
ACCRINTM |
Returns the accrued interest for a security that pays interest at maturity |
|
AMORDEGRC |
Returns the depreciation for each accounting period by using a depreciation coefficient |
|
AMORLINC |
Returns the depreciation for each accounting period |
|
COUPDAYBS |
Returns the number of days from the beginning of the coupon period to the settlement date |
|
COUPDAYS |
Returns the number of days in the coupon period that contains the settlement date |
|
COUPDAYSNC |
Returns the number of days from the settlement date to the next coupon date |
|
COUPNCD |
Returns the next coupon date after the settlement date |
|
COUPNUM |
Returns the number of coupons payable between the settlement date and maturity date |
|
COUPPCD |
Returns the previous coupon date before the settlement date |
|
CUMIPMT |
Returns the cumulative interest paid between two periods |
|
CUMPRINC |
Returns the cumulative principal paid on a loan between two periods |
|
DB |
Returns the depreciation of an asset for a specified period by using the fixed-declining balance method |
|
DDB |
Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify |
|
DISC |
Returns the discount rate for a security |
|
DOLLARDE |
Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number |
|
DOLLARFR |
Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction |
|
DURATION |
Returns the annual duration of a security with periodic interest payments |
|
EFFECT |
Returns the effective annual interest rate |
|
FV |
Returns the future value of an investment |
|
FVSCHEDULE |
Returns the future value of an initial principal after applying a series of compound interest rates |
|
INTRATE |
Returns the interest rate for a fully invested security |
|
IPMT |
Returns the interest payment for an investment for a given period |
|
IRR |
Returns the internal rate of return for a series of cash flows |
|
ISPMT |
Calculates the interest paid during a specific period of an investment |
|
MDURATION |
Returns the Macauley modified duration for a security with an assumed par value of $100 |
|
MIRR |
Returns the internal rate of return where positive and negative cash flows are financed at different rates |
|
NOMINAL |
Returns the annual nominal interest rate |
|
NPER |
Returns the number of periods for an investment |
|
NPV |
Returns the net present value of an investment based on a series of periodic cash flows and a discount rate |
|
ODDFPRICE |
Returns the price per $100 face value of a security with an odd first period |
|
ODDFYIELD |
Returns the yield of a security with an odd first period |
|
ODDLPRICE |
Returns the price per $100 face value of a security with an odd last period |
|
ODDLYIELD |
Returns the yield of a security with an odd last period |
|
PMT |
Returns the periodic payment for an annuity |
|
PPMT |
Returns the payment on the principal for an investment for a given period |
|
PRICE |
Returns the price per $100 face value of a security that pays periodic interest |
|
PRICEDISC |
Returns the price per $100 face value of a discounted security |
|
PRICEMAT |
Returns the price per $100 face value of a security that pays interest at maturity |
|
PV |
Returns the present value of an investment |
|
RATE |
Returns the interest rate per period of an annuity |
|
RECEIVED |
Returns the amount received at maturity for a fully invested security |
|
SLN |
Returns the straight-line depreciation of an asset for one period |
|
SYD |
Returns the sum-of-years' digits depreciation of an asset for a specified period |
|
TBILLEQ |
Returns the bond-equivalent yield for a Treasury bill |
|
TBILLPRICE |
Returns the price per $100 face value for a Treasury bill |
|
TBILLYIELD |
Returns the yield for a Treasury bill |
|
VDB |
Returns the depreciation of an asset for a specified or partial period by using a declining balance method |
|
XIRR |
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic |
|
XNPV |
Returns the net present value for a schedule of cash flows that is not necessarily periodic |
|
YIELD |
Returns the yield on a security that pays periodic interest |
|
YIELDDISC |
Returns the annual yield for a discounted security; for example, a Treasury bill |
|
YIELDMAT |
Returns the annual yield of a security that pays interest at maturity |
|
|
|
|
|
|
|
|
|
|
Information functions |
توابع اطلاعاتی |
|
|
|
|
Function |
Description |
|
CELL |
Returns information about the formatting, location, or contents of a cell |
|
ERROR.TYPE |
Returns a number corresponding to an error type |
|
INFO |
Returns information about the current operating environment |
|
ISBLANK |
Returns TRUE if the value is blank |
|
ISERR |
Returns TRUE if the value is any error value except #N/A |
|
ISERROR |
Returns TRUE if the value is any error value |
|
ISEVEN |
Returns TRUE if the number is even |
|
ISLOGICAL |
Returns TRUE if the value is a logical value |
|
ISNA |
Returns TRUE if the value is the #N/A error value |
|
ISNONTEXT |
Returns TRUE if the value is not text |
|
ISNUMBER |
Returns TRUE if the value is a number |
|
ISODD |
Returns TRUE if the number is odd |
|
ISREF |
Returns TRUE if the value is a reference |
|
ISTEXT |
Returns TRUE if the value is text |
|
N |
Returns a value converted to a number |
|
NA |
Returns the error value #N/A |
|
TYPE |
Returns a number indicating the data type of a value |
|
Top of Page |
|
|
|
|
|
|
|
|
Logical functions |
توابع منطقی |
|
|
|
|
Function |
Description |
|
AND |
Returns TRUE if all of its arguments are TRUE |
|
FALSE |
Returns the logical value FALSE |
|
IF |
Specifies a logical test to perform |
|
NOT |
Reverses the logic of its argument |
|
OR |
Returns TRUE if any argument is TRUE |
|
TRUE |
Returns the logical value TRUE |
|
|
|
|
|
|
|
|
|
|
Lookup and reference functions |
توابع جستجو و آدرس |
|
|
|
|
Function |
Description |
|
ADDRESS |
Returns a reference as text to a single cell in a worksheet |
|
AREAS |
Returns the number of areas in a reference |
|
CHOOSE |
Chooses a value from a list of values |
|
COLUMN |
Returns the column number of a reference |
|
COLUMNS |
Returns the number of columns in a reference |
|
GETPIVOTDATA |
Returns data stored in a PivotTable |
|
HLOOKUP |
Looks in the top row of an array and returns the value of the indicated cell |
|
HYPERLINK |
Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet |
|
INDEX |
Uses an index to choose a value from a reference or array |
|
INDIRECT |
Returns a reference indicated by a text value |
|
LOOKUP |
Looks up values in a vector or array |
|
MATCH |
Looks up values in a reference or array |
|
OFFSET |
Returns a reference offset from a given reference |
|
ROW |
Returns the row number of a reference |
|
ROWS |
Returns the number of rows in a reference |
|
RTD |
Retrieves real-time data from a program that supports COM automation (Automation: A way to work with an application's objects from another application or development tool. Formerly called OLE Automation, Automation is an industry standard and a feature of the Component Object Model (COM).) |
|
TRANSPOSE |
Returns the transpose of an array |
|
VLOOKUP |
Looks in the first column of an array and moves across the row to return the value of a cell |
|
|
|
|
|
|
|
|
|
|
Math and trigonometry functions |
توابع ریاضیات و مثلثات |
|
|
|
|
Function |
Description |
|
ABS |
Returns the absolute value of a number |
|
ACOS |
Returns the arccosine of a number |
|
ACOSH |
Returns the inverse hyperbolic cosine of a number |
|
ASIN |
Returns the arcsine of a number |
|
ASINH |
Returns the inverse hyperbolic sine of a number |
|
ATAN |
Returns the arctangent of a number |
|
ATAN2 |
Returns the arctangent from x- and y-coordinates |
|
ATANH |
Returns the inverse hyperbolic tangent of a number |
|
CEILING |
Rounds a number to the nearest integer or to the nearest multiple of significance |
|
COMBIN |
Returns the number of combinations for a given number of objects |
|
COS |
Returns the cosine of a number |
|
COSH |
Returns the hyperbolic cosine of a number |
|
DEGREES |
Converts radians to degrees |
|
EVEN |
Rounds a number up to the nearest even integer |
|
EXP |
Returns e raised to the power of a given number |
|
FACT |
Returns the factorial of a number |
|
FACTDOUBLE |
Returns the double factorial of a number |
|
FLOOR |
Rounds a number down, toward zero |
|
GCD |
Returns the greatest common divisor |
|
INT |
Rounds a number down to the nearest integer |
|
LCM |
Returns the least common multiple |
|
LN |
Returns the natural logarithm of a number |
|
LOG |
Returns the logarithm of a number to a specified base |
|
LOG10 |
Returns the base-10 logarithm of a number |
|
MDETERM |
Returns the matrix determinant of an array |
|
MINVERSE |
Returns the matrix inverse of an array |
|
MMULT |
Returns the matrix product of two arrays |
|
MOD |
Returns the remainder from division |
|
MROUND |
Returns a number rounded to the desired multiple |
|
MULTINOMIAL |
Returns the multinomial of a set of numbers |
|
ODD |
Rounds a number up to the nearest odd integer |
|
PI |
Returns the value of pi |
|
POWER |
Returns the result of a number raised to a power |
|
PRODUCT |
Multiplies its arguments |
|
QUOTIENT |
Returns the integer portion of a division |
|
RADIANS |
Converts degrees to radians |
بنام خدا