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

From Apache OpenOffice Wiki
Jump to: navigation, search
Line 148: Line 148:
  
 
;[[Documentation/How_Tos/Calc:_Information_functions|Information  Functions]]
 
;[[Documentation/How_Tos/Calc:_Information_functions|Information  Functions]]
 +
:[[Documentation/How_Tos/Calc:_CELL_function|Cell]]
 +
:[[Documentation/How_Tos/Calc:_CURRENT_function|Current]]
 +
:[[Documentation/How_Tos/Calc:_FORMULA_function|Formula]]
 +
:[[Documentation/How_Tos/Calc:_ISBLANK_function|Isblank]]
 +
:[[Documentation/How_Tos/Calc:_ISERR_function|Iserr]]
 +
:[[Documentation/How_Tos/Calc:_ISERROR_function|Iserror]]
 +
:[[Documentation/How_Tos/Calc:_ISEVEN_function|Iseven]]
 +
:[[Documentation/How_Tos/Calc:_ISEVEN_ADD_function|Iseven Add]]
 +
:[[Documentation/How_Tos/Calc:_ISLOGICAL_function|Islogical]]
 +
:[[Documentation/How_Tos/Calc:_ISNA_function|Isna]]
 +
:[[Documentation/How_Tos/Calc:_ISNONTEXT_function|Isnontext]]
 +
:[[Documentation/How_Tos/Calc:_ISNUMBER_function|Isnumber]]
 +
:[[Documentation/How_Tos/Calc:_ISODD_function|Isodd]]
 +
:[[Documentation/How_Tos/Calc:_ISODD_ADD_function|Isodd Add]]
 +
:[[Documentation/How_Tos/Calc:_ISREF_function|Isref]]
 +
:[[Documentation/How_Tos/Calc:_ISTEXT_function|Istext]]
 +
:[[Documentation/How_Tos/Calc:_N_function|N]]
 +
:[[Documentation/How_Tos/Calc:_NA_function|Na]]
 +
:[[Documentation/How_Tos/Calc:_TYPE_function|Type]]
  
 
;[[Documentation/How_Tos/Calc:_Logical_functions|Logical Functions]]
 
;[[Documentation/How_Tos/Calc:_Logical_functions|Logical Functions]]
 +
:[[Documentation/How_Tos/Calc:_AND_function|And]]
 +
:[[Documentation/How_Tos/Calc:_FALSE_function|False]]
 +
:[[Documentation/How_Tos/Calc:_IF_function|If]]
 +
:[[Documentation/How_Tos/Calc:_NOT_function|Not]]
 +
:[[Documentation/How_Tos/Calc:_OR_function|Or]]
 +
:[[Documentation/How_Tos/Calc:_TRUE_function|True]]
  
 
;[[Documentation/How_Tos/Calc:_Mathematical_functions|Matematical Functions]]
 
;[[Documentation/How_Tos/Calc:_Mathematical_functions|Matematical Functions]]

Revision as of 00:23, 22 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
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

Cumipmt
Cumipmt Add
Cumprinc
Cumpinc Add
Fv
Fvschedule
Ipmt
Irr
Ispmt
Mirr
Nper
Npv
Pmt
Ppmt
Pv
Rate
Rri
Xirr
Xnpv

Securities

Accrint
Accrintm
Disc
Duration
Duration Add
Effective
Effect Add
Intrate
Mduration
Duration Add
Nominal
Nominal Add
Oddfprice
Oddfyield

Coupons

Coupdaybs
Coupdays
Coupdaysnc
Coupncd
Coupnum
Couppcd

Miscellaneous

Coupdaybs
Coupdays
Information Functions
Cell
Current
Formula
Isblank
Iserr
Iserror
Iseven
Iseven Add
Islogical
Isna
Isnontext
Isnumber
Isodd
Isodd Add
Isref
Istext
N
Na
Type
Logical Functions
And
False
If
Not
Or
True
Matematical Functions
Number Conversion Functions
Spreadsheet Functions
Statistical Functions
Text Functions
Views
Personal tools
Navigation
Tools