Difference between revisions of "Documentation/SL/How Tos/Calc: Funkcije po kategorijah"
From Apache OpenOffice Wiki
< Documentation | SL/How Tos
(→Funkcije programa Calc po kategorijah) |
|||
Line 1: | Line 1: | ||
__NOTOC__ | __NOTOC__ | ||
− | + | {{DISPLAYTITLE:Funkcije po kategorijah}} | |
== Funkcije programa Calc po kategorijah == | == Funkcije programa Calc po kategorijah == | ||
These pages are a complete rewrite of the Help for Calc. Not alls are included yet. The aim is for descriptions to be more precise, complete and consistent than before. | These pages are a complete rewrite of the Help for Calc. Not alls are included yet. The aim is for descriptions to be more precise, complete and consistent than before. |
Revision as of 19:52, 20 July 2008
Funkcije programa Calc po kategorijah
These pages are a complete rewrite of the Help for Calc. Not alls are included yet. The aim is for descriptions to be more precise, complete and consistent than before.
You may
- navigate directly to thes from this page, or
- select a category, to find a one line description of each and some explanatory notes on the category.
Funkcije za kompleksna števila
- The Complex Numbers 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 Databases 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 & Times 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 Financials provide common business calculations.
- The Informations 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 Logicals include boolean logic AND, OR, NOTs, ands such as IF which test a logical result.
- AND, FALSE, IF, NOT, OR, TRUE
- The Mathematicals include trigonometric, hyperbolic, logarithmic and summations.
- 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 Conversions convert numbers between forms.
- BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX
- ARABIC, BAHTTEXT, DECIMAL, ROMAN
- The Arrays operate on and return entire tables of data.
- FREQUENCY, GROWTH, LINEST, LOGEST, MDETERM, MINVERSE, MMULT, MUNIT, SUMPRODUCT, SUMX2MY2, SUMX2PY2, SUMXMY2, TRANSPOSE, TREND
- The Statisticals provide statistical and probability calculations.
- AVEDEV AVERAGE AVERAGEA B BETADIST BETAINV BINOMDIST COUNT COUNTA CHIDIST CHIINV CHITEST CONFIDENCE CORREL COVAR CRITBINOM DEVSQ EXPONDIST FINV FISHER FISHERINV FDIST FORECAST FTEST GAMMAINV GAMMALN GAMMADIST GAUSS GEOMEAN HARMEAN HYPGEOMDIST INTERCEPT KURT LARGE LOGINV LOGNORMDIST MAX MAXA MEDIAN MIN MINA MODE NEGBINOMDIST NORMINV NORMDIST NORMSINV NORMSDIST PEARSON PERCENTILE PERCENTRANK PERMUT PERMUTATIONA PHI POISSON PROB QUARTILE RANK RSQ SKEW SLOPE SMALL STANDARDIZE STDEV STDEVA STDEVP STDEVPA STEYX TDIST TINV TRIMMEAN TTEST VAR VARA VARP VARPA WEIBULL ZTEST