Difference between revisions of "Documentation/SL/How Tos/Calc: Funkcije po kategorijah"
From Apache OpenOffice Wiki
< Documentation | SL/How Tos
| (2 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
__NOTOC__ | __NOTOC__ | ||
| − | {{DISPLAYTITLE: | + | {{DISPLAYTITLE:Funkcije programa Calc po kategorijah}} |
| − | + | ||
Te strani so popolnoma novo napisana pomoč za modul Calc. Nekatere funkcije še manjkajo. Namen je, da bi bili opisi bolj natančni, popolni in konsistentni kot prej. | Te strani so popolnoma novo napisana pomoč za modul Calc. Nekatere funkcije še manjkajo. Namen je, da bi bili opisi bolj natančni, popolni in konsistentni kot prej. | ||
| Line 38: | Line 37: | ||
:[[Documentation/SL/How_Tos/Calc: funkcija TRUNC|TRUNC]], [[Documentation/SL/How_Tos/Calc: funkcija ROUND|ROUND]], [[Documentation/SL/How_Tos/Calc: funkcija ROUNDDOWN|ROUNDDOWN]], [[Documentation/SL/How_Tos/Calc: funkcija ROUNDUP|ROUNDUP]], [[Documentation/SL/How_Tos/Calc: funkcija CEILING|CEILING]], [[Documentation/SL/How_Tos/Calc: funkcija FLOOR|FLOOR]], [[Documentation/SL/How_Tos/Calc: funkcija EVEN|EVEN]], [[Documentation/SL/How_Tos/Calc: funkcija ODD|ODD]], [[Documentation/SL/How_Tos/Calc: funkcija MROUND|MROUND]], [[Documentation/SL/How_Tos/Calc: funkcija INT|INT]], [[Documentation/SL/How_Tos/Calc: funkcija QUOTIENT|QUOTIENT]], [[Documentation/SL/How_Tos/Calc: funkcija MOD|MOD]] | :[[Documentation/SL/How_Tos/Calc: funkcija TRUNC|TRUNC]], [[Documentation/SL/How_Tos/Calc: funkcija ROUND|ROUND]], [[Documentation/SL/How_Tos/Calc: funkcija ROUNDDOWN|ROUNDDOWN]], [[Documentation/SL/How_Tos/Calc: funkcija ROUNDUP|ROUNDUP]], [[Documentation/SL/How_Tos/Calc: funkcija CEILING|CEILING]], [[Documentation/SL/How_Tos/Calc: funkcija FLOOR|FLOOR]], [[Documentation/SL/How_Tos/Calc: funkcija EVEN|EVEN]], [[Documentation/SL/How_Tos/Calc: funkcija ODD|ODD]], [[Documentation/SL/How_Tos/Calc: funkcija MROUND|MROUND]], [[Documentation/SL/How_Tos/Calc: funkcija INT|INT]], [[Documentation/SL/How_Tos/Calc: funkcija QUOTIENT|QUOTIENT]], [[Documentation/SL/How_Tos/Calc: funkcija MOD|MOD]] | ||
:[[Documentation/SL/How_Tos/Calc: funkcija EXP|EXP]], [[Documentation/SL/How_Tos/Calc: funkcija POWER|POWER]], [[Documentation/SL/How_Tos/Calc: funkcija LOG|LOG]], [[Documentation/SL/How_Tos/Calc: funkcija LN|LN]], [[Documentation/SL/How_Tos/Calc: funkcija LOG10|LOG10]] | :[[Documentation/SL/How_Tos/Calc: funkcija EXP|EXP]], [[Documentation/SL/How_Tos/Calc: funkcija POWER|POWER]], [[Documentation/SL/How_Tos/Calc: funkcija LOG|LOG]], [[Documentation/SL/How_Tos/Calc: funkcija LN|LN]], [[Documentation/SL/How_Tos/Calc: funkcija LOG10|LOG10]] | ||
| − | :[[Documentation/SL/How_Tos/Calc: funkcija ABS|ABS]], [[Documentation/SL/How_Tos/Calc: funkcija COMBIN|COMBIN]], [[Documentation/SL/How_Tos/Calc: funkcija COMBINA|COMBINA]], [[Documentation/SL/How_Tos/Calc: funkcija CONVERT|CONVERT]], [[Documentation/SL/How_Tos/Calc: | + | :[[Documentation/SL/How_Tos/Calc: funkcija ABS|ABS]], [[Documentation/SL/How_Tos/Calc: funkcija COMBIN|COMBIN]], [[Documentation/SL/How_Tos/Calc: funkcija COMBINA|COMBINA]], [[Documentation/SL/How_Tos/Calc: funkcija CONVERT|CONVERT]], [[Documentation/SL/How_Tos/Calc: Funkcija CONVERT_ADD|CONVERT_ADD]], [[Documentation/SL/How_Tos/Calc: funkcija COUNTBLANK|COUNTBLANK]], [[Documentation/SL/How_Tos/Calc: funkcija COUNTIF|COUNTIF]], [[Documentation/SL/How_Tos/Calc: funkcija DELTA|DELTA]], [[Documentation/SL/How_Tos/Calc: funkcija ERF|ERF]], [[Documentation/SL/How_Tos/Calc: funkcija ERFC|ERFC]], [[Documentation/SL/How_Tos/Calc: funkcija FACT|FACT]], [[Documentation/SL/How_Tos/Calc: funkcija FACTDOUBLE|FACTDOUBLE]], [[Documentation/SL/How_Tos/Calc: funkcija GCD|GCD]], [[Documentation/SL/How_Tos/Calc: funkcija GCD_ADD|GCD_ADD]], [[Documentation/SL/How_Tos/Calc: funkcija GESTEP|GESTEP]], [[Documentation/SL/How_Tos/Calc: funkcija ISEVEN|ISEVEN]], [[Documentation/SL/How_Tos/Calc: funkcija ISODD|ISODD]], [[Documentation/SL/How_Tos/Calc: funkcija LCM|LCM]], [[Documentation/SL/How_Tos/Calc: funkcija LCM_ADD|LCM_ADD]], [[Documentation/SL/How_Tos/Calc: funkcija MULTINOMIAL|MULTINOMIAL]], [[Documentation/SL/How_Tos/Calc: funkcija PRODUCT|PRODUCT]], [[Documentation/SL/How_Tos/Calc: funkcija RAND|RAND]], [[Documentation/SL/How_Tos/Calc: funkcija RANDBETWEEN|RANDBETWEEN]], [[Documentation/SL/How_Tos/Calc: funkcija SERIESSUM|SERIESSUM]], [[Documentation/SL/How_Tos/Calc: funkcija SIGN|SIGN]], [[Documentation/SL/How_Tos/Calc: funkcija SQRT|SQRT]], [[Documentation/SL/How_Tos/Calc: funkcija SQRTPI|SQRTPI]], [[Documentation/SL/How_Tos/Calc: funkcija SUBTOTAL|SUBTOTAL]], [[Documentation/SL/How_Tos/Calc: funkcija SUM|SUM]], [[Documentation/SL/How_Tos/Calc: funkcija SUMIF|SUMIF]], [[Documentation/SL/How_Tos/Calc: funkcija SUMSQ|SUMSQ]] |
:[[Documentation/SL/How_Tos/Calc: funkcija BESSELI|BESSELI]], [[Documentation/SL/How_Tos/Calc: funkcija BESSELJ|BESSELJ]], [[Documentation/SL/How_Tos/Calc: funkcija BESSELK|BESSELK]], [[Documentation/SL/How_Tos/Calc: funkcija BESSELY|BESSELY]] | :[[Documentation/SL/How_Tos/Calc: funkcija BESSELI|BESSELI]], [[Documentation/SL/How_Tos/Calc: funkcija BESSELJ|BESSELJ]], [[Documentation/SL/How_Tos/Calc: funkcija BESSELK|BESSELK]], [[Documentation/SL/How_Tos/Calc: funkcija BESSELY|BESSELY]] | ||
| Line 64: | Line 63: | ||
:[[Documentation/SL/How_Tos/Calc: funkcija BASE|BASE]], [[Documentation/SL/How_Tos/Calc: funkcija CHAR|CHAR]], [[Documentation/SL/How_Tos/Calc: funkcija CLEAN|CLEAN]], [[Documentation/SL/How_Tos/Calc: funkcija CODE|CODE]], [[Documentation/SL/How_Tos/Calc: funkcija CONCATENATE|CONCATENATE]], [[Documentation/SL/How_Tos/Calc: funkcija DOLLAR|DOLLAR]], [[Documentation/SL/How_Tos/Calc: funkcija EXACT|EXACT]], [[Documentation/SL/How_Tos/Calc: funkcija FIND|FIND]], [[Documentation/SL/How_Tos/Calc: funkcija FIXED|FIXED]], [[Documentation/SL/How_Tos/Calc: funkcija LEFT|LEFT]], [[Documentation/SL/How_Tos/Calc: funkcija LEN|LEN]], [[Documentation/SL/How_Tos/Calc: funkcija LOWER|LOWER]], [[Documentation/SL/How_Tos/Calc: funkcija MID|MID]], [[Documentation/SL/How_Tos/Calc: funkcija PROPER|PROPER]], [[Documentation/SL/How_Tos/Calc: funkcija REPLACE|REPLACE]], [[Documentation/SL/How_Tos/Calc: funkcija REPT|REPT]], [[Documentation/SL/How_Tos/Calc: funkcija RIGHT|RIGHT]], [[Documentation/SL/How_Tos/Calc: funkcija SEARCH|SEARCH]], [[Documentation/SL/How_Tos/Calc: funkcija SUBSTITUTE|SUBSTITUTE]], [[Documentation/SL/How_Tos/Calc: funkcija T|T]], [[Documentation/SL/How_Tos/Calc: funkcija TEXT|TEXT]], [[Documentation/SL/How_Tos/Calc: funkcija TRIM|TRIM]], [[Documentation/SL/How_Tos/Calc: funkcija UPPER|UPPER]], [[Documentation/SL/How_Tos/Calc: funkcija VALUE|VALUE]] | :[[Documentation/SL/How_Tos/Calc: funkcija BASE|BASE]], [[Documentation/SL/How_Tos/Calc: funkcija CHAR|CHAR]], [[Documentation/SL/How_Tos/Calc: funkcija CLEAN|CLEAN]], [[Documentation/SL/How_Tos/Calc: funkcija CODE|CODE]], [[Documentation/SL/How_Tos/Calc: funkcija CONCATENATE|CONCATENATE]], [[Documentation/SL/How_Tos/Calc: funkcija DOLLAR|DOLLAR]], [[Documentation/SL/How_Tos/Calc: funkcija EXACT|EXACT]], [[Documentation/SL/How_Tos/Calc: funkcija FIND|FIND]], [[Documentation/SL/How_Tos/Calc: funkcija FIXED|FIXED]], [[Documentation/SL/How_Tos/Calc: funkcija LEFT|LEFT]], [[Documentation/SL/How_Tos/Calc: funkcija LEN|LEN]], [[Documentation/SL/How_Tos/Calc: funkcija LOWER|LOWER]], [[Documentation/SL/How_Tos/Calc: funkcija MID|MID]], [[Documentation/SL/How_Tos/Calc: funkcija PROPER|PROPER]], [[Documentation/SL/How_Tos/Calc: funkcija REPLACE|REPLACE]], [[Documentation/SL/How_Tos/Calc: funkcija REPT|REPT]], [[Documentation/SL/How_Tos/Calc: funkcija RIGHT|RIGHT]], [[Documentation/SL/How_Tos/Calc: funkcija SEARCH|SEARCH]], [[Documentation/SL/How_Tos/Calc: funkcija SUBSTITUTE|SUBSTITUTE]], [[Documentation/SL/How_Tos/Calc: funkcija T|T]], [[Documentation/SL/How_Tos/Calc: funkcija TEXT|TEXT]], [[Documentation/SL/How_Tos/Calc: funkcija TRIM|TRIM]], [[Documentation/SL/How_Tos/Calc: funkcija UPPER|UPPER]], [[Documentation/SL/How_Tos/Calc: funkcija VALUE|VALUE]] | ||
| − | {{ | + | {{SeeAlso|EN| |
*[[Documentation/SL/How_Tos/Calc: Funkcije po abecedi|Funkcije po abecedi]] | *[[Documentation/SL/How_Tos/Calc: Funkcije po abecedi|Funkcije po abecedi]] | ||
}} | }} | ||
Latest revision as of 09:36, 17 July 2018
Te strani so popolnoma novo napisana pomoč za modul Calc. Nekatere funkcije še manjkajo. Namen je, da bi bili opisi bolj natančni, popolni in konsistentni kot prej.
Lahko
- krmarite neposredno nanje s ste strani ali
- izberete kategorijo, tako dobite enovrstičen opis vsake in nekaj dodatnih pojasnil o kategoriji.
- si ogledate seznam funkcije po abecedi.
Funkcije za kompleksna števila
- Kompleksna števila delujejo na (matematičnih) kompleksnih številih, kot je 2 + 3i.
- COMPLEX, IMABS, IMAGINARY, IMPOWER, IMARGUMENT, IMCOS, IMDIV, IMEXP, IMCONJUGATE, IMLN, IMLOG10, IMLOG2, IMPRODUCT, IMREAL, IMSIN, IMSUB, IMSUM, IMSQRT
- Zbirke podatkov uporabljamo za izluščanje podatkov iz podatkovnih tabel v Calcu, kjer so podatki organizirani v vrstice.
- DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DAVERAGE, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP
- Funkcije za datum in čas uporabljamo za računanje datumov in čas.
- 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
- Finančne funkcije zagotavljajo pogoste poslovne izračune.
- Informacijske funkcije vrnejo podatke o celicah, kot je to, ali vsebujejo besedilo ali formulo itn.
- CELL, CURRENT, FORMULA, ISBLANK, ISERR, ISERROR, ISEVEN, ISEVEN_ADD, ISFORMULA, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISODD_ADD, ISREF, ISTEXT, N, NA, TYPE
- Logične funkcije vključujejo dvojiško logiko AND (IN), OR (ALI), NOT (NE), kot tudi IF (ČE), ki preizkušajo dvojiški rezultat.
- AND, FALSE, IF, NOT, OR, TRUE
- Vključujejo trigonometrične, hiperbolične, logaritemske in vsotne funkcije.
- 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
- Pretvarjajo števila med različnimi pojavnimi oblikami.
- BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX
- ARABIC, BAHTTEXT, DECIMAL, ROMAN
- Delujejo na matrikah in vrnejo cele tabele podatkov.
- FREQUENCY, GROWTH, LINEST, LOGEST, MDETERM, MINVERSE, MMULT, MUNIT, SUMPRODUCT, SUMX2MY2, SUMX2PY2, SUMXMY2, TRANSPOSE, TREND
- Ponujajo računanje statistike in verjetnosti.
- 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
- Iščejo vrednosti v tabelah ali sklicih na celice.
- ADDRESS, CHOOSE, HLOOKUP, INDEX, INDIRECT, LOOKUP, MATCH, OFFSET, VLOOKUP
- AREAS, COLUMN, COLUMNS, ERRORTYPE, INFO, ROW, ROWS, SHEET, SHEETS
- DDE, HYPERLINK, STYLE
- Obdelujejo besedilo ali ga vrnejo.
- BASE, CHAR, CLEAN, CODE, CONCATENATE, DOLLAR, EXACT, FIND, FIXED, LEFT, LEN, LOWER, MID, PROPER, REPLACE, REPT, RIGHT, SEARCH, SUBSTITUTE, T, TEXT, TRIM, UPPER, VALUE
See Also
| Content on this page is licensed under the Public Documentation License (PDL). |
