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

From Apache OpenOffice Wiki
Jump to: navigation, search
Line 59: Line 59:
  
 
;[[Documentation/How_Tos/Calc:_Date_%26_Time_functions|Data & Time Functions]]
 
;[[Documentation/How_Tos/Calc:_Date_%26_Time_functions|Data & Time Functions]]
 +
:[[Documentation/How_Tos/Calc:_TODAY_function|Today]]
 +
:[[Documentation/How_Tos/Calc:_NOW_function|Now]]
 +
:[[Documentation/How_Tos/Calc:_YEAR_function|Year]]
 +
:[[Documentation/How_Tos/Calc:_MONTH_function|Month]]
 +
:[[Documentation/How_Tos/Calc:_DAY_function|Day]]
 +
:[[Documentation/How_Tos/Calc:_WEEKDAY_function|Weekday]]
 +
:[[Documentation/How_Tos/Calc:_HOUR_function|Hour]]
 +
:[[Documentation/How_Tos/Calc:_MINUTE_function|Minute]]
 +
:[[Documentation/How_Tos/Calc:_SECOND_function|Second]]
 +
:[[Documentation/How_Tos/Calc:_DATE_function|Date]]
 +
:[[Documentation/How_Tos/Calc:_DATEVALUE_function|Datevalue]]
 +
:[[Documentation/How_Tos/Calc:_TIME_function|Time]]
 +
:[[Documentation/How_Tos/Calc:_TIMEVALUE_function|Timevalue]]
 +
:[[Documentation/How_Tos/Calc:_EOMONTH_function|Eomonth]]
 +
:[[Documentation/How_Tos/Calc:_EDATE_function|Edate]]
 +
:[[Documentation/How_Tos/Calc:_WORKDAY_function|Workday]]
 +
:[[Documentation/How_Tos/Calc:_NETWORKDAYS_function|Networkdays]]
 +
:[[Documentation/How_Tos/Calc:_DAYS_function|Days]]
 +
:[[Documentation/How_Tos/Calc:_DAYS360_function|Days360]]
 +
:[[Documentation/How_Tos/Calc:_DAYSINMONTH_function|Daysinmonth]]
 +
:[[Documentation/How_Tos/Calc:_DAYSINYEAR_function|Daysinyear]]
 +
:[[Documentation/How_Tos/Calc:_WEEKS_function|Weeks]]
 +
:[[Documentation/How_Tos/Calc:_WEEKSINYEAR_function|Weeksinyear]]
 +
:[[Documentation/How_Tos/Calc:_WEEKNUM_function|Weeknum]]
 +
:[[Documentation/How_Tos/Calc:_WEEKNUM_ADD_function|Weeknum_add]]
 +
:[[Documentation/How_Tos/Calc:_MONTHS_function|Months]]
 +
:[[Documentation/How_Tos/Calc:_YEARS_function|Years]]
 +
:[[Documentation/How_Tos/Calc:_ISLEAPYEAR_function|Isleapyear]]
 +
:[[Documentation/How_Tos/Calc:_EASTERSUNDAY_function|Eastersunday]]
 +
:[[Documentation/How_Tos/Calc:_YEARFRAC_function|Yearfrac]]
  
 
;[[Documentation/How_Tos/Calc:_Financial_functions|Financial Functions]]
 
;[[Documentation/How_Tos/Calc:_Financial_functions|Financial Functions]]

Revision as of 19:15, 15 June 2013

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
Information Functions
Logical Functions
Matematical Functions
Number Conversion Functions
Spreadsheet Functions
Statistical Functions
Text Functions
Personal tools