Difference between revisions of "MediaWiki talk:Collections/Calc functions"
From Apache OpenOffice Wiki
Javier Lopez (talk | contribs) |
Javier Lopez (talk | contribs) |
||
Line 93: | Line 93: | ||
;[[Documentation/How_Tos/Calc:_Financial_functions|Financial Functions]] | ;[[Documentation/How_Tos/Calc:_Financial_functions|Financial Functions]] | ||
+ | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Depreciation</div> | ||
+ | :[[Documentation/How_Tos/Calc:_AMORDEGRC_function|Amordegrc]] | ||
+ | :[[Documentation/How_Tos/Calc:_AMORLINC_function|Amorlinc]] | ||
+ | :[[Documentation/How_Tos/Calc:_DB_function|Db]] | ||
+ | :[[Documentation/How_Tos/Calc:_DDB_function|Ddb]] | ||
+ | :[[Documentation/How_Tos/Calc:_SLN_function|Sln]] | ||
+ | :[[Documentation/How_Tos/Calc:_SYD_function|Syd]] | ||
+ | :[[Documentation/How_Tos/Calc:_VDB_function|Vdb]] | ||
+ | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Payment Streams, Annuities, Loans</div> | ||
+ | :[[Documentation/How_Tos/Calc:_CUMIPMT_function|Cumipmt]] | ||
+ | :[[Documentation/How_Tos/Calc:_CUMIPMT_ADD_function|Cumipmt Add]] | ||
+ | :[[Documentation/How_Tos/Calc:_CUMPRINC_function|Cumprinc]] | ||
+ | :[[Documentation/How_Tos/Calc:_CUMPRINC_ADD_function|Cumpinc Add]] | ||
+ | :[[Documentation/How_Tos/Calc:_FV_function|Fv]] | ||
+ | : [[Documentation/How_Tos/Calc:_FVSCHEDULE_function|Fvschedule]] | ||
+ | :[[Documentation/How_Tos/Calc:_IPMT_function|Ipmt]] | ||
+ | :[[Documentation/How_Tos/Calc:_IRR_function|Irr]] | ||
+ | :[[Documentation/How_Tos/Calc:_ISPMT_function|Ispmt]] | ||
+ | :[[Documentation/How_Tos/Calc:_MIRR_function|Mirr]] | ||
+ | :[[Documentation/How_Tos/Calc:_NPER_function|Nper]] | ||
+ | :[[Documentation/How_Tos/Calc:_NPV_function|Npv]] | ||
+ | :[[Documentation/How_Tos/Calc:_PMT_function|Pmt]] | ||
+ | :[[Documentation/How_Tos/Calc:_PPMT_function|Ppmt]] | ||
+ | :[[Documentation/How_Tos/Calc:_PV_function|Pv]] | ||
+ | :[[Documentation/How_Tos/Calc:_RATE_function|Rate]] | ||
+ | :[[Documentation/How_Tos/Calc:_RRI_function|Rri]] | ||
+ | :[[Documentation/How_Tos/Calc:_XIRR_function|Xirr]] | ||
+ | :[[Documentation/How_Tos/Calc:_XNPV_function|Xnpv]] | ||
+ | |||
+ | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Securities</div> | ||
+ | * [[Documentation/How_Tos/Calc:_ACCRINT_function|<div style="font-size: 120%;">Accrint]] | ||
+ | * [[Documentation/How_Tos/Calc:_ACCRINTM_function|<div style="font-size: 120%;">Accrintm]] | ||
+ | * [[Documentation/How_Tos/Calc:_DISC_function|<div style="font-size: 120%;">Disc]] | ||
+ | * [[Documentation/How_Tos/Calc:_DURATION_function|<div style="font-size: 120%;">Duration]] | ||
+ | * [[Documentation/How_Tos/Calc:_DURATION_ADD_function|<div style="font-size: 120%;">Duration Add]] | ||
+ | * [[Documentation/How_Tos/Calc:_EFFECTIVE_function|<div style="font-size: 120%;">Effective]] | ||
+ | * [[Documentation/How_Tos/Calc:_EFFECT_ADD_function|<div style="font-size: 120%;">Effect Add]] | ||
+ | * [[Documentation/How_Tos/Calc:_INTRATE_function|<div style="font-size: 120%;">Intrate]] | ||
+ | * [[Documentation/How_Tos/Calc:_MDURATION_function|<div style="font-size: 120%;">Mduration]] | ||
+ | * [[Documentation/How_Tos/Calc:_DURATION_ADD_function|<div style="font-size: 120%;">Duration Add]] | ||
+ | * [[Documentation/How_Tos/Calc:_NOMINAL_function|<div style="font-size: 120%;">Nominal]] | ||
+ | * [[Documentation/How_Tos/Calc:_NOMINAL_ADD_function|<div style="font-size: 120%;">Nominal Add]] | ||
+ | * [[Documentation/How_Tos/Calc:_ODDFPRICE_function|<div style="font-size: 120%;">Oddfprice]] | ||
+ | * [[Documentation/How_Tos/Calc:_ODDFYIELD_function|<div style="font-size: 120%;">Oddfyield]] | ||
+ | |||
+ | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Coupons</div> | ||
+ | * [[Documentation/How_Tos/Calc:_COUPDAYBS_function|<div style="font-size: 120%;">Coupdaybs]] | ||
+ | * [[Documentation/How_Tos/Calc:_COUPDAYS_function|<div style="font-size: 120%;">Coupdays]] | ||
+ | * [[Documentation/How_Tos/Calc:_COUPDAYSNC_function|<div style="font-size: 120%;">Coupdaysnc]] | ||
+ | * [[Documentation/How_Tos/Calc:_COUPNCD_function|<div style="font-size: 120%;">Coupncd]] | ||
+ | * [[Documentation/How_Tos/Calc:_COUPNUM_function|<div style="font-size: 120%;">Coupnum]] | ||
+ | * [[Documentation/How_Tos/Calc:_COUPPCD_function|<div style="font-size: 120%;">Couppcd]] | ||
+ | |||
+ | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Miscellaneous</div> | ||
+ | * [[Documentation/How_Tos/Calc:_DOLLARDE_function|<div style="font-size: 120%;">Coupdaybs]] | ||
+ | * [[Documentation/How_Tos/Calc:_DOLLARFR_function|<div style="font-size: 120%;">Coupdays]] | ||
;[[Documentation/How_Tos/Calc:_Information_functions|Information Functions]] | ;[[Documentation/How_Tos/Calc:_Information_functions|Information Functions]] |
Revision as of 23:32, 21 June 2013
This is a user-generated collection of Wikibooks pages that can be easily saved, rendered electronically, and ordered as a printed book. If you are the creator of this collection and need help, see Help:Collections. |
Calc Functions
- Arrays Functions
- Frequency
- Growth
- Linest
- Longest
- Mdeterm
- Minverse
- Mmult
- Munit
- Sumproduct
- vSumx2my2
- Sumx2py2
- Sumxmy2
- Transpose
- Trend
- Complex Number functions
- Complex
- Imabs
- Imaginary
- Imargument
- Imconjugate
- Imcos
- Imcosh
- Imcsc
- Imcsch
- Imcot
- Imdiv
- Imexp
- Imln
- Imlog10
- Imlog2
- Impower
- Improduct
- Imreal
- Imsec
- Imsech
- Imsin
- Imsinh
- Imsqrt
- Imsub
- Imsum
- Imtan
- Data & Time Functions
- Today
- Now
- Year
- Month
- Day
- Weekday
- Hour
- Minute
- Second
- Date
- Datevalue
- Time
- Timevalue
- Eomonth
- Edate
- Workday
- Networkdays
- Days
- Days360
- Daysinmonth
- Daysinyear
- Weeks
- Weeksinyear
- Weeknum
- Weeknum_add
- Months
- Years
- Isleapyear
- Eastersunday
- Yearfrac
Depreciation
Payment Streams, Annuities, Loans
- Cumipmt
- Cumipmt Add
- Cumprinc
- Cumpinc Add
- Fv
- Fvschedule
- Ipmt
- Irr
- Ispmt
- Mirr
- Nper
- Npv
- Pmt
- Ppmt
- Pv
- Rate
- Rri
- Xirr
- Xnpv
Securities
Coupons
Miscellaneous