Difference between revisions of "MediaWiki talk:Collections/Calc 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.

Download PDF

Open in Collection Creator

Order Printed Book

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

Database Functions: Dcount; Dcounta; Dget; Dmax; Dmin; Daverage; Dproduct; Dstdev; Dsum; Dvar; Dvarp

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

Financial Functions

Depreciation

Amordegrc

Amorlinc

Db

Ddb

Sln

Syd

Vdb

Payment Streams, Annuities, Loans

Fv

Irr

Npv

Pmt

Ppmt

Pv

Rate

Rri

Xirr

Xnpv

Securities

Coupons

Miscellaneous

Information Functions

Logical Functions

Matematical Functions
Number Conversion Functions
Spreadsheet Functions
Statistical Functions
Text Functions

@@ Line 93: / Line 93: @@
 ;[[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]]

Difference between revisions of "MediaWiki talk:Collections/Calc functions"

Revision as of 23:32, 21 June 2013

Calc Functions

Views

Personal tools

Navigation

Search

Tools