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

Revision as of 23:39, 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>
+Depreciation
 :[[Documentation/How_Tos/Calc:_AMORDEGRC_function|Amordegrc]]
 :[[Documentation/How_Tos/Calc:_AMORLINC_function|Amorlinc]]
@@ Line 101: / Line 101: @@
 :[[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>
+Payment Streams, Annuities, Loans
 :[[Documentation/How_Tos/Calc:_CUMIPMT_function|Cumipmt]]
 :[[Documentation/How_Tos/Calc:_CUMIPMT_ADD_function|Cumipmt Add]]
@@ Line 121: / Line 121: @@
 :[[Documentation/How_Tos/Calc:_XIRR_function|Xirr]]
 :[[Documentation/How_Tos/Calc:_XNPV_function|Xnpv]]
+Securities
-<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Securities</div>
+:[[Documentation/How_Tos/Calc:_ACCRINT_function|Accrint]]
-* [[Documentation/How_Tos/Calc:_ACCRINT_function|<div style="font-size: 120%;">Accrint]]
+:[[Documentation/How_Tos/Calc:_ACCRINTM_function|Accrintm]]
-* [[Documentation/How_Tos/Calc:_ACCRINTM_function|<div style="font-size: 120%;">Accrintm]]
+:[[Documentation/How_Tos/Calc:_DISC_function|Disc]]
-* [[Documentation/How_Tos/Calc:_DISC_function|<div style="font-size: 120%;">Disc]]
+:[[Documentation/How_Tos/Calc:_DURATION_function|Duration]]
-* [[Documentation/How_Tos/Calc:_DURATION_function|<div style="font-size: 120%;">Duration]]
+:[[Documentation/How_Tos/Calc:_DURATION_ADD_function|Duration Add]]
-* [[Documentation/How_Tos/Calc:_DURATION_ADD_function|<div style="font-size: 120%;">Duration Add]]
+:[[Documentation/How_Tos/Calc:_EFFECTIVE_function|Effective]]
-* [[Documentation/How_Tos/Calc:_EFFECTIVE_function|<div style="font-size: 120%;">Effective]]
+:[[Documentation/How_Tos/Calc:_EFFECT_ADD_function|Effect Add]]
-* [[Documentation/How_Tos/Calc:_EFFECT_ADD_function|<div style="font-size: 120%;">Effect Add]]
+:[[Documentation/How_Tos/Calc:_INTRATE_function|Intrate]]
-* [[Documentation/How_Tos/Calc:_INTRATE_function|<div style="font-size: 120%;">Intrate]]
+:[[Documentation/How_Tos/Calc:_MDURATION_function|Mduration]]
-* [[Documentation/How_Tos/Calc:_MDURATION_function|<div style="font-size: 120%;">Mduration]]
+:[[Documentation/How_Tos/Calc:_DURATION_ADD_function|Duration Add]]
-* [[Documentation/How_Tos/Calc:_DURATION_ADD_function|<div style="font-size: 120%;">Duration Add]]
+:[[Documentation/How_Tos/Calc:_NOMINAL_function|Nominal]]
-* [[Documentation/How_Tos/Calc:_NOMINAL_function|<div style="font-size: 120%;">Nominal]]
+:[[Documentation/How_Tos/Calc:_NOMINAL_ADD_function|Nominal Add]]
-* [[Documentation/How_Tos/Calc:_NOMINAL_ADD_function|<div style="font-size: 120%;">Nominal Add]]
+:[[Documentation/How_Tos/Calc:_ODDFPRICE_function|Oddfprice]]
-* [[Documentation/How_Tos/Calc:_ODDFPRICE_function|<div style="font-size: 120%;">Oddfprice]]
+:[[Documentation/How_Tos/Calc:_ODDFYIELD_function|Oddfyield]]
-* [[Documentation/How_Tos/Calc:_ODDFYIELD_function|<div style="font-size: 120%;">Oddfyield]]
+Coupons
+:[[Documentation/How_Tos/Calc:_COUPDAYBS_function|Coupdaybs]]
-<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Coupons</div>
+:[[Documentation/How_Tos/Calc:_COUPDAYS_function|Coupdays]]
-* [[Documentation/How_Tos/Calc:_COUPDAYBS_function|<div style="font-size: 120%;">Coupdaybs]]
+:[[Documentation/How_Tos/Calc:_COUPDAYSNC_function|Coupdaysnc]]
-* [[Documentation/How_Tos/Calc:_COUPDAYS_function|<div style="font-size: 120%;">Coupdays]]
+:[[Documentation/How_Tos/Calc:_COUPNCD_function|Coupncd]]
-* [[Documentation/How_Tos/Calc:_COUPDAYSNC_function|<div style="font-size: 120%;">Coupdaysnc]]
+:[[Documentation/How_Tos/Calc:_COUPNUM_function|Coupnum]]
-* [[Documentation/How_Tos/Calc:_COUPNCD_function|<div style="font-size: 120%;">Coupncd]]
+:[[Documentation/How_Tos/Calc:_COUPPCD_function|Couppcd]]
-* [[Documentation/How_Tos/Calc:_COUPNUM_function|<div style="font-size: 120%;">Coupnum]]
+Miscellaneous
-* [[Documentation/How_Tos/Calc:_COUPPCD_function|<div style="font-size: 120%;">Couppcd]]
+:[[Documentation/How_Tos/Calc:_DOLLARDE_function|Coupdaybs]]
+:[[Documentation/How_Tos/Calc:_DOLLARFR_function|Coupdays]]
-<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:39, 21 June 2013

Calc Functions

Views

Personal tools

Navigation

Search

Tools