Difference between revisions of "Template:Calc functions"
From Apache OpenOffice Wiki
(added 3 fns) |
(moved fns to Num Conversion cat) |
||
Line 45: | Line 45: | ||
:The Number Conversion functions convert numbers between forms. | :The Number Conversion functions convert numbers between forms. | ||
:[[Documentation/How_Tos/Calc: BIN2DEC function|BIN2DEC]] [[Documentation/How_Tos/Calc: BIN2HEX function|BIN2HEX]] [[Documentation/How_Tos/Calc: BIN2OCT function|BIN2OCT]] [[Documentation/How_Tos/Calc: DEC2BIN function|DEC2BIN]] [[Documentation/How_Tos/Calc: DEC2HEX function|DEC2HEX]] [[Documentation/How_Tos/Calc: DEC2OCT function|DEC2OCT]] [[Documentation/How_Tos/Calc: HEX2BIN function|HEX2BIN]] [[Documentation/How_Tos/Calc: HEX2DEC function|HEX2DEC]] [[Documentation/How_Tos/Calc: HEX2OCT function|HEX2OCT]] [[Documentation/How_Tos/Calc: OCT2BIN function|OCT2BIN]] [[Documentation/How_Tos/Calc: OCT2DEC function|OCT2DEC]] [[Documentation/How_Tos/Calc: OCT2HEX function|OCT2HEX]] | :[[Documentation/How_Tos/Calc: BIN2DEC function|BIN2DEC]] [[Documentation/How_Tos/Calc: BIN2HEX function|BIN2HEX]] [[Documentation/How_Tos/Calc: BIN2OCT function|BIN2OCT]] [[Documentation/How_Tos/Calc: DEC2BIN function|DEC2BIN]] [[Documentation/How_Tos/Calc: DEC2HEX function|DEC2HEX]] [[Documentation/How_Tos/Calc: DEC2OCT function|DEC2OCT]] [[Documentation/How_Tos/Calc: HEX2BIN function|HEX2BIN]] [[Documentation/How_Tos/Calc: HEX2DEC function|HEX2DEC]] [[Documentation/How_Tos/Calc: HEX2OCT function|HEX2OCT]] [[Documentation/How_Tos/Calc: OCT2BIN function|OCT2BIN]] [[Documentation/How_Tos/Calc: OCT2DEC function|OCT2DEC]] [[Documentation/How_Tos/Calc: OCT2HEX function|OCT2HEX]] | ||
+ | :[[Documentation/How_Tos/Calc: ARABIC function|ARABIC]] [[Documentation/How_Tos/Calc: BAHTTEXT function|BAHTTEXT]] [[Documentation/How_Tos/Calc: DECIMAL function|DECIMAL]] [[Documentation/How_Tos/Calc: ROMAN function|ROMAN]] | ||
'''[[Documentation/How_Tos/Calc: Array functions|Array functions]]''' | '''[[Documentation/How_Tos/Calc: Array functions|Array functions]]''' | ||
Line 61: | Line 62: | ||
'''[[Documentation/How_Tos/Calc: Text functions|Text functions]]''' | '''[[Documentation/How_Tos/Calc: Text functions|Text functions]]''' | ||
:The Text functions manipulate or return text. | :The Text functions manipulate or return text. | ||
− | : | + | :[[Documentation/How_Tos/Calc: BASE function|BASE]] [[Documentation/How_Tos/Calc: CHAR function|CHAR]] [[Documentation/How_Tos/Calc: CLEAN function|CLEAN]] [[Documentation/How_Tos/Calc: CODE function|CODE]] [[Documentation/How_Tos/Calc: CONCATENATE function|CONCATENATE]] [[Documentation/How_Tos/Calc: DOLLAR function|DOLLAR]] [[Documentation/How_Tos/Calc: EXACT function|EXACT]] [[Documentation/How_Tos/Calc: FIND function|FIND]] [[Documentation/How_Tos/Calc: FIXED function|FIXED]] [[Documentation/How_Tos/Calc: LEFT function|LEFT]] [[Documentation/How_Tos/Calc: LEN function|LEN]] [[Documentation/How_Tos/Calc: LOWER function|LOWER]] [[Documentation/How_Tos/Calc: MID function|MID]] [[Documentation/How_Tos/Calc: PROPER function|PROPER]] [[Documentation/How_Tos/Calc: REPLACE function|REPLACE]] [[Documentation/How_Tos/Calc: REPT function|REPT]] [[Documentation/How_Tos/Calc: RIGHT function|RIGHT]] [[Documentation/How_Tos/Calc: SEARCH function|SEARCH]] [[Documentation/How_Tos/Calc: SUBSTITUTE function|SUBSTITUTE]] [[Documentation/How_Tos/Calc: T function|T]] [[Documentation/How_Tos/Calc: TEXT function|TEXT]] [[Documentation/How_Tos/Calc: TRIM function|TRIM]] [[Documentation/How_Tos/Calc: UPPER function|UPPER]] [[Documentation/How_Tos/Calc: VALUE function|VALUE]] |
Revision as of 08:31, 27 February 2008
Calc functions listed by category
These pages are a complete rewrite of the Function Help for Calc. Not all functions are included yet. The aim is for descriptions to be more precise, complete and consistent than before.
You may
- navigate directly to the functions from this page, or
- select a function category, to find a one line description of each function and some explanatory notes on the category.
The categories shown here are also used by the Function Wizard.
- The Complex Number functions operate on (mathematical) complex numbers such as 2 + 3i.
- COMPLEX IMABS IMAGINARY IMPOWER IMARGUMENT IMCOS IMDIV IMEXP IMCONJUGATE IMLN IMLOG10 IMLOG2 IMPRODUCT IMREAL IMSIN IMSUB IMSUM IMSQRT
- The Database functions are used to extract information from Calc data tables, where data is organised in rows.
- DCOUNT DCOUNTA DGET DMAX DMIN DAVERAGE DPRODUCT DSTDEV DSTDEVP DSUM DVAR DVARP
- The Date & Time functions are used to manipulate dates and times.
- 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
- The Financial functions provide common business calculations.
- The Information functions return information about cells, such as whether they contain text or a formula, etc.
- CELL CURRENT FORMULA ISBLANK ISERR ISERROR ISEVEN ISEVEN_ADD ISFORMULA ISLOGICAL ISNA ISNONTEXT ISNUMBER ISODD ISODD_ADD ISREF ISTEXT N NA TYPE
- The Logical functions include boolean logic AND, OR, NOT functions, and functions such as IF which test a logical result.
- AND FALSE IF NOT OR TRUE
- The Mathematical functions include trigonometric, hyperbolic, logarithmic and summation functions.
- COS SIN TAN COT ACOS ACOT ASIN ATAN ATAN2 DEGREES RADIANS PI
- COSH SINH TANH COTH ACOSH ACOTH ASINH ATANH
- TRUNC ROUND ROUNDDOWN ROUNDUP CEILING FLOOR EVEN ODD MROUND INT QUOTIENT MOD
- EXP POWER LOG LN LOG10
- ABS COMBIN COMBINA CONVERT CONVERT_ADD COUNTBLANK COUNTIF DELTA ERF ERFC FACT FACTDOUBLE GCD GCD_ADD GESTEP ISEVEN ISODD LCM LCM_ADD MULTINOMIAL PRODUCT RAND RANDBETWEEN SERIESSUM SIGN SQRT SQRTPI SUBTOTAL SUM SUMIF SUMSQ
- BESSELI BESSELJ BESSELK BESSELY
- The Number Conversion functions convert numbers between forms.
- BIN2DEC BIN2HEX BIN2OCT DEC2BIN DEC2HEX DEC2OCT HEX2BIN HEX2DEC HEX2OCT OCT2BIN OCT2DEC OCT2HEX
- ARABIC BAHTTEXT DECIMAL ROMAN
- The Array functions operate on and return entire tables of data.
- FREQUENCY GROWTH LINEST LOGEST MDETERM MINVERSE MMULT MUNIT SUMPRODUCT SUMX2MY2 SUMX2PY2 SUMXMY2 TRANSPOSE TREND
- The Statistical functions allow statistical analysis of data.