Difference between revisions of "Documentation/SL/How Tos/Calc: Funkcije po kategorijah"
From Apache OpenOffice Wiki
< Documentation | SL/How Tos
(New page: __NOTOC__ == Funkcije programa Calc po kategorijah == These pages are a complete rewrite of the Function Help for Calc. Not all functions are included yet. The aim is for descriptions to ...) |
(→Funkcije programa Calc po kategorijah) |
||
Line 2: | Line 2: | ||
== Funkcije programa Calc po kategorijah == | == Funkcije programa Calc po kategorijah == | ||
− | These pages are a complete rewrite of the | + | 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 | You may | ||
− | *navigate directly to | + | *navigate directly to thes from this page, or |
− | *select a | + | *select a category, to find a one line description of each and some explanatory notes on the category. |
'''[[Documentation/SL/How_Tos/Calc: Funkcije za kompleksna števila|Funkcije za kompleksna števila]]''' | '''[[Documentation/SL/How_Tos/Calc: Funkcije za kompleksna števila|Funkcije za kompleksna števila]]''' | ||
− | : The Complex | + | : The Complex Numbers operate on (mathematical) complex numbers such as 2 + 3i. |
− | :[[Documentation/How_Tos/Calc: COMPLEX | + | :[[Documentation/SL/How_Tos/Calc: funkcija COMPLEX|COMPLEX]], [[Documentation/SL/How_Tos/Calc: funkcija IMABS|IMABS]], [[Documentation/SL/How_Tos/Calc: funkcija IMAGINARY|IMAGINARY]], [[Documentation/SL/How_Tos/Calc: funkcija IMPOWER|IMPOWER]], [[Documentation/SL/How_Tos/Calc: funkcija IMARGUMENT|IMARGUMENT]], [[Documentation/SL/How_Tos/Calc: funkcija IMCOS|IMCOS]], [[Documentation/SL/How_Tos/Calc: funkcija IMDIV|IMDIV]], [[Documentation/SL/How_Tos/Calc: funkcija IMEXP|IMEXP]], [[Documentation/SL/How_Tos/Calc: funkcija IMCONJUGATE|IMCONJUGATE]], [[Documentation/SL/How_Tos/Calc: funkcija IMLN|IMLN]], [[Documentation/SL/How_Tos/Calc: funkcija IMLOG10|IMLOG10]], [[Documentation/SL/How_Tos/Calc: funkcija IMLOG2|IMLOG2]], [[Documentation/SL/How_Tos/Calc: funkcija IMPRODUCT|IMPRODUCT]], [[Documentation/SL/How_Tos/Calc: funkcija IMREAL|IMREAL]], [[Documentation/SL/How_Tos/Calc: funkcija IMSIN|IMSIN]], [[Documentation/SL/How_Tos/Calc: funkcija IMSUB|IMSUB]], [[Documentation/SL/How_Tos/Calc: funkcija IMSUM|IMSUM]], [[Documentation/SL/How_Tos/Calc: funkcija IMSQRT|IMSQRT]] |
'''[[Documentation/SL/How_Tos/Calc: Funkcije za zbirke podatkov|Funkcije za zbirke podatkov]]''' | '''[[Documentation/SL/How_Tos/Calc: Funkcije za zbirke podatkov|Funkcije za zbirke podatkov]]''' | ||
− | :The | + | :The Databases are used to extract information from Calc data tables, where data is organised in rows. |
− | :[[Documentation/How_Tos/Calc: DCOUNT | + | :[[Documentation/SL/How_Tos/Calc: funkcija DCOUNT|DCOUNT]], [[Documentation/SL/How_Tos/Calc: funkcija DCOUNTA|DCOUNTA]], [[Documentation/SL/How_Tos/Calc: funkcija DGET|DGET]], [[Documentation/SL/How_Tos/Calc: funkcija DMAX|DMAX]], [[Documentation/SL/How_Tos/Calc: funkcija DMIN|DMIN]], [[Documentation/SL/How_Tos/Calc: funkcija DAVERAGE|DAVERAGE]], [[Documentation/SL/How_Tos/Calc: funkcija DPRODUCT|DPRODUCT]], [[Documentation/SL/How_Tos/Calc: funkcija DSTDEV|DSTDEV]], [[Documentation/SL/How_Tos/Calc: funkcija DSTDEVP|DSTDEVP]], [[Documentation/SL/How_Tos/Calc: funkcija DSUM|DSUM]], [[Documentation/SL/How_Tos/Calc: funkcija DVAR|DVAR]], [[Documentation/SL/How_Tos/Calc: funkcija DVARP|DVARP]] |
− | '''[[Documentation/How_Tos/Calc: | + | '''[[Documentation/SL/How_Tos/Calc: Datumske in časovne funkcije|Datumske in časovne funkcije]]''' |
− | :The Date & | + | :The Date & Times are used to manipulate dates and times. |
− | :[[Documentation/How_Tos/Calc: TODAY | + | :[[Documentation/SL/How_Tos/Calc: funkcija TODAY |TODAY]], [[Documentation/SL/How_Tos/Calc: funkcija NOW|NOW]], [[Documentation/SL/How_Tos/Calc: funkcija YEAR|YEAR]], [[Documentation/SL/How_Tos/Calc: funkcija MONTH|MONTH]], [[Documentation/SL/How_Tos/Calc: funkcija DAY|DAY]], [[Documentation/SL/How_Tos/Calc: funkcija WEEKDAY|WEEKDAY]], [[Documentation/SL/How_Tos/Calc: funkcija HOUR|HOUR]], [[Documentation/SL/How_Tos/Calc: funkcija MINUTE|MINUTE]], [[Documentation/SL/How_Tos/Calc: funkcija SECOND|SECOND]], [[Documentation/SL/How_Tos/Calc: funkcija DATE|DATE]], [[Documentation/SL/How_Tos/Calc: funkcija DATEVALUE|DATEVALUE]], [[Documentation/SL/How_Tos/Calc: funkcija TIME|TIME]], [[Documentation/SL/How_Tos/Calc: funkcija TIMEVALUE|TIMEVALUE]], [[Documentation/SL/How_Tos/Calc: funkcija EOMONTH|EOMONTH]], [[Documentation/SL/How_Tos/Calc: funkcija EDATE|EDATE]], [[Documentation/SL/How_Tos/Calc: funkcija WORKDAY|WORKDAY]], [[Documentation/SL/How_Tos/Calc: funkcija NETWORKDAYS|NETWORKDAYS]], [[Documentation/SL/How_Tos/Calc: funkcija DAYS|DAYS]], [[Documentation/SL/How_Tos/Calc: funkcija DAYS360|DAYS360]], [[Documentation/SL/How_Tos/Calc: funkcija DAYSINMONTH|DAYSINMONTH]], [[Documentation/SL/How_Tos/Calc: funkcija DAYSINYEAR|DAYSINYEAR]], [[Documentation/SL/How_Tos/Calc: funkcija WEEKS|WEEKS]], [[Documentation/SL/How_Tos/Calc: funkcija WEEKSINYEAR|WEEKSINYEAR]], [[Documentation/SL/How_Tos/Calc: funkcija WEEKNUM|WEEKNUM]], [[Documentation/SL/How_Tos/Calc: funkcija WEEKNUM_ADD|WEEKNUM_ADD]], [[Documentation/SL/How_Tos/Calc: funkcija MONTHS|MONTHS]], [[Documentation/SL/How_Tos/Calc: funkcija YEARS|YEARS]], [[Documentation/SL/How_Tos/Calc: funkcija ISLEAPYEAR|ISLEAPYEAR]], [[Documentation/SL/How_Tos/Calc: funkcija EASTERSUNDAY|EASTERSUNDAY]], [[Documentation/SL/How_Tos/Calc: funkcija YEARFRAC|YEARFRAC]] |
'''[[Documentation/SL/How_Tos/Calc: Finančne funkcije|Finančne funkcije]]''' | '''[[Documentation/SL/How_Tos/Calc: Finančne funkcije|Finančne funkcije]]''' | ||
− | :The | + | :The Financials provide common business calculations. |
'''[[Documentation/SL/How_Tos/Calc: Informacijske funkcije|Informacijske funkcije]]''' | '''[[Documentation/SL/How_Tos/Calc: Informacijske funkcije|Informacijske funkcije]]''' | ||
− | :The | + | :The Informations return information about cells, such as whether they contain text or a formula, etc. |
− | :[[Documentation/How_Tos/Calc: CELL | + | :[[Documentation/SL/How_Tos/Calc: funkcija CELL|CELL]], [[Documentation/SL/How_Tos/Calc: funkcija CURRENT|CURRENT]], [[Documentation/SL/How_Tos/Calc: funkcija FORMULA|FORMULA]], [[Documentation/SL/How_Tos/Calc: funkcija ISBLANK|ISBLANK]], [[Documentation/SL/How_Tos/Calc: funkcija ISERR|ISERR]], [[Documentation/SL/How_Tos/Calc: funkcija ISERROR|ISERROR]], [[Documentation/SL/How_Tos/Calc: funkcija ISEVEN|ISEVEN]], [[Documentation/SL/How_Tos/Calc: funkcija ISEVEN_ADD|ISEVEN_ADD]], [[Documentation/SL/How_Tos/Calc: funkcija ISFORMULA|ISFORMULA]], [[Documentation/SL/How_Tos/Calc: funkcija ISLOGICAL|ISLOGICAL]], [[Documentation/SL/How_Tos/Calc: funkcija ISNA|ISNA]], [[Documentation/SL/How_Tos/Calc: funkcija ISNONTEXT|ISNONTEXT]], [[Documentation/SL/How_Tos/Calc: funkcija ISNUMBER|ISNUMBER]], [[Documentation/SL/How_Tos/Calc: funkcija ISODD|ISODD]], [[Documentation/SL/How_Tos/Calc: funkcija ISODD_ADD|ISODD_ADD]], [[Documentation/SL/How_Tos/Calc: funkcija ISREF|ISREF]], [[Documentation/SL/How_Tos/Calc: funkcija ISTEXT|ISTEXT]], [[Documentation/SL/How_Tos/Calc: funkcija N|N]], [[Documentation/SL/How_Tos/Calc: funkcija NA|NA]], [[Documentation/SL/How_Tos/Calc: funkcija TYPE|TYPE]] |
'''[[Documentation/SL/How_Tos/Calc: Logične funkcije|Logične funkcije]]''' | '''[[Documentation/SL/How_Tos/Calc: Logične funkcije|Logične funkcije]]''' | ||
− | :The | + | :The Logicals include boolean logic '''AND''', '''OR''', '''NOT'''s, ands such as '''IF''' which test a logical result. |
− | :[[Documentation/How_Tos/Calc: AND | + | :[[Documentation/SL/How_Tos/Calc: funkcija AND|AND]], [[Documentation/SL/How_Tos/Calc: funkcija FALSE|FALSE]], [[Documentation/SL/How_Tos/Calc: funkcija IF|IF]], [[Documentation/SL/How_Tos/Calc: funkcija NOT|NOT]], [[Documentation/SL/How_Tos/Calc: funkcija OR|OR]], [[Documentation/SL/How_Tos/Calc: funkcija TRUE|TRUE]] |
'''[[Documentation/SL/How_Tos/Calc: Matematične funkcije|Matematične funkcije]]''' | '''[[Documentation/SL/How_Tos/Calc: Matematične funkcije|Matematične funkcije]]''' | ||
− | :The | + | :The Mathematicals include trigonometric, hyperbolic, logarithmic and summations. |
− | :[[Documentation/How_Tos/Calc: COS | + | :[[Documentation/SL/How_Tos/Calc: funkcija COS|COS]], [[Documentation/SL/How_Tos/Calc: funkcija SIN|SIN]], [[Documentation/SL/How_Tos/Calc: funkcija TAN|TAN]], [[Documentation/SL/How_Tos/Calc: funkcija COT|COT]], [[Documentation/SL/How_Tos/Calc: funkcija ACOS|ACOS]], [[Documentation/SL/How_Tos/Calc: funkcija ACOT|ACOT]], [[Documentation/SL/How_Tos/Calc: funkcija ASIN|ASIN]], [[Documentation/SL/How_Tos/Calc: funkcija ATAN|ATAN]], [[Documentation/SL/How_Tos/Calc: funkcija ATAN2|ATAN2]], [[Documentation/SL/How_Tos/Calc: funkcija DEGREES|DEGREES]], [[Documentation/SL/How_Tos/Calc: funkcija RADIANS|RADIANS]], [[Documentation/SL/How_Tos/Calc: funkcija PI|PI]] |
− | :[[Documentation/How_Tos/Calc: COSH | + | :[[Documentation/SL/How_Tos/Calc: funkcija COSH|COSH]], [[Documentation/SL/How_Tos/Calc: funkcija SINH|SINH]], [[Documentation/SL/How_Tos/Calc: funkcija TANH|TANH]], [[Documentation/SL/How_Tos/Calc: funkcija COTH|COTH]], [[Documentation/SL/How_Tos/Calc: funkcija ACOSH|ACOSH]], [[Documentation/SL/How_Tos/Calc: funkcija ACOTH|ACOTH]], [[Documentation/SL/How_Tos/Calc: funkcija ASINH|ASINH]], [[Documentation/SL/How_Tos/Calc: funkcija ATANH|ATANH]] |
− | :[[Documentation/How_Tos/Calc: TRUNC | + | :[[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/How_Tos/Calc: EXP | + | :[[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/How_Tos/Calc: ABS | + | :[[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/How_Tos/Calc: BESSELI | + | :[[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: Funkcije za pretvorbo števil|Funkcije za pretvorbo števil]]''' | '''[[Documentation/SL/How_Tos/Calc: Funkcije za pretvorbo števil|Funkcije za pretvorbo števil]]''' | ||
− | :The Number | + | :The Number Conversions convert numbers between forms. |
− | :[[Documentation/How_Tos/Calc: BIN2DEC | + | :[[Documentation/SL/How_Tos/Calc: funkcija BIN2DEC|BIN2DEC]], [[Documentation/SL/How_Tos/Calc: funkcija BIN2HEX|BIN2HEX]], [[Documentation/SL/How_Tos/Calc: funkcija BIN2OCT|BIN2OCT]], [[Documentation/SL/How_Tos/Calc: funkcija DEC2BIN|DEC2BIN]], [[Documentation/SL/How_Tos/Calc: funkcija DEC2HEX|DEC2HEX]], [[Documentation/SL/How_Tos/Calc: funkcija DEC2OCT|DEC2OCT]], [[Documentation/SL/How_Tos/Calc: funkcija HEX2BIN|HEX2BIN]], [[Documentation/SL/How_Tos/Calc: funkcija HEX2DEC|HEX2DEC]], [[Documentation/SL/How_Tos/Calc: funkcija HEX2OCT|HEX2OCT]], [[Documentation/SL/How_Tos/Calc: funkcija OCT2BIN|OCT2BIN]], [[Documentation/SL/How_Tos/Calc: funkcija OCT2DEC|OCT2DEC]], [[Documentation/SL/How_Tos/Calc: funkcija OCT2HEX|OCT2HEX]] |
− | :[[Documentation/How_Tos/Calc: ARABIC | + | :[[Documentation/SL/How_Tos/Calc: funkcija ARABIC|ARABIC]], [[Documentation/SL/How_Tos/Calc: funkcija BAHTTEXT|BAHTTEXT]], [[Documentation/SL/How_Tos/Calc: funkcija DECIMAL|DECIMAL]], [[Documentation/SL/How_Tos/Calc: funkcija ROMAN|ROMAN]] |
'''[[Documentation/SL/How_Tos/Calc: Matrične funkcije|Matrične funkcije]]''' | '''[[Documentation/SL/How_Tos/Calc: Matrične funkcije|Matrične funkcije]]''' | ||
− | :The | + | :The Arrays operate on and return entire tables of data. |
− | :[[Documentation/How_Tos/Calc: FREQUENCY | + | :[[Documentation/SL/How_Tos/Calc: funkcija FREQUENCY|FREQUENCY]], [[Documentation/SL/How_Tos/Calc: funkcija GROWTH|GROWTH]], [[Documentation/SL/How_Tos/Calc: funkcija LINEST|LINEST]], [[Documentation/SL/How_Tos/Calc: funkcija LOGEST|LOGEST]], [[Documentation/SL/How_Tos/Calc: funkcija MDETERM|MDETERM]], [[Documentation/SL/How_Tos/Calc: funkcija MINVERSE|MINVERSE]], [[Documentation/SL/How_Tos/Calc: funkcija MMULT|MMULT]], [[Documentation/SL/How_Tos/Calc: funkcija MUNIT|MUNIT]], [[Documentation/SL/How_Tos/Calc: funkcija SUMPRODUCT|SUMPRODUCT]], [[Documentation/SL/How_Tos/Calc: funkcija SUMX2MY2|SUMX2MY2]], [[Documentation/SL/How_Tos/Calc: funkcija SUMX2PY2|SUMX2PY2]], [[Documentation/SL/How_Tos/Calc: funkcija SUMXMY2|SUMXMY2]], [[Documentation/SL/How_Tos/Calc: funkcija TRANSPOSE|TRANSPOSE]], [[Documentation/SL/How_Tos/Calc: funkcija TREND|TREND]] |
'''[[Documentation/SL/How_Tos/Calc: Statistične funkcije|Statistične funkcije]]''' | '''[[Documentation/SL/How_Tos/Calc: Statistične funkcije|Statistične funkcije]]''' | ||
− | :The | + | :The Statisticals provide statistical and probability calculations. |
− | :[[Documentation/How_Tos/Calc: AVEDEV | + | :[[Documentation/SL/How_Tos/Calc: funkcija AVEDEV|AVEDEV]] [[Documentation/SL/How_Tos/Calc: funkcija AVERAGE|AVERAGE]] [[Documentation/SL/How_Tos/Calc: funkcija AVERAGEA|AVERAGEA]] [[Documentation/SL/How_Tos/Calc: funkcija B|B]] [[Documentation/SL/How_Tos/Calc: funkcija BETADIST|BETADIST]] [[Documentation/SL/How_Tos/Calc: funkcija BETAINV|BETAINV]] [[Documentation/SL/How_Tos/Calc: funkcija BINOMDIST|BINOMDIST]] [[Documentation/SL/How_Tos/Calc: funkcija COUNT|COUNT]] [[Documentation/SL/How_Tos/Calc: funkcija COUNTA|COUNTA]] [[Documentation/SL/How_Tos/Calc: funkcija CHIDIST|CHIDIST]] [[Documentation/SL/How_Tos/Calc: funkcija CHIINV|CHIINV]] [[Documentation/SL/How_Tos/Calc: funkcija CHITEST|CHITEST]] [[Documentation/SL/How_Tos/Calc: funkcija CONFIDENCE|CONFIDENCE]] [[Documentation/SL/How_Tos/Calc: funkcija CORREL|CORREL]] [[Documentation/SL/How_Tos/Calc: funkcija COVAR|COVAR]] [[Documentation/SL/How_Tos/Calc: funkcija CRITBINOM|CRITBINOM]] [[Documentation/SL/How_Tos/Calc: funkcija DEVSQ|DEVSQ]] [[Documentation/SL/How_Tos/Calc: funkcija EXPONDIST|EXPONDIST]] [[Documentation/SL/How_Tos/Calc: funkcija FINV|FINV]] [[Documentation/SL/How_Tos/Calc: funkcija FISHER|FISHER]] [[Documentation/SL/How_Tos/Calc: funkcija FISHERINV|FISHERINV]] [[Documentation/SL/How_Tos/Calc: funkcija FDIST|FDIST]] [[Documentation/SL/How_Tos/Calc: funkcija FORECAST|FORECAST]] [[Documentation/SL/How_Tos/Calc: funkcija FTEST|FTEST]] [[Documentation/SL/How_Tos/Calc: funkcija GAMMAINV|GAMMAINV]] [[Documentation/SL/How_Tos/Calc: funkcija GAMMALN|GAMMALN]] [[Documentation/SL/How_Tos/Calc: funkcija GAMMADIST|GAMMADIST]] [[Documentation/SL/How_Tos/Calc: funkcija GAUSS|GAUSS]] [[Documentation/SL/How_Tos/Calc: funkcija GEOMEAN|GEOMEAN]] [[Documentation/SL/How_Tos/Calc: funkcija HARMEAN|HARMEAN]] [[Documentation/SL/How_Tos/Calc: funkcija HYPGEOMDIST|HYPGEOMDIST]] [[Documentation/SL/How_Tos/Calc: funkcija INTERCEPT|INTERCEPT]] [[Documentation/SL/How_Tos/Calc: funkcija KURT|KURT]] [[Documentation/SL/How_Tos/Calc: funkcija LARGE|LARGE]] [[Documentation/SL/How_Tos/Calc: funkcija LOGINV|LOGINV]] [[Documentation/SL/How_Tos/Calc: funkcija LOGNORMDIST|LOGNORMDIST]] [[Documentation/SL/How_Tos/Calc: funkcija MAX|MAX]] [[Documentation/SL/How_Tos/Calc: funkcija MAXA|MAXA]] [[Documentation/SL/How_Tos/Calc: funkcija MEDIAN|MEDIAN]] [[Documentation/SL/How_Tos/Calc: funkcija MIN|MIN]] [[Documentation/SL/How_Tos/Calc: funkcija MINA|MINA]] [[Documentation/SL/How_Tos/Calc: funkcija MODE|MODE]] [[Documentation/SL/How_Tos/Calc: funkcija NEGBINOMDIST|NEGBINOMDIST]] [[Documentation/SL/How_Tos/Calc: funkcija NORMINV|NORMINV]] [[Documentation/SL/How_Tos/Calc: funkcija NORMDIST|NORMDIST]] [[Documentation/SL/How_Tos/Calc: funkcija NORMSINV|NORMSINV]] [[Documentation/SL/How_Tos/Calc: funkcija NORMSDIST|NORMSDIST]] [[Documentation/SL/How_Tos/Calc: funkcija PEARSON|PEARSON]] [[Documentation/SL/How_Tos/Calc: funkcija PERCENTILE|PERCENTILE]] [[Documentation/SL/How_Tos/Calc: funkcija PERCENTRANK|PERCENTRANK]] [[Documentation/SL/How_Tos/Calc: funkcija PERMUT|PERMUT]] [[Documentation/SL/How_Tos/Calc: funkcija PERMUTATIONA|PERMUTATIONA]] [[Documentation/SL/How_Tos/Calc: funkcija PHI|PHI]] [[Documentation/SL/How_Tos/Calc: funkcija POISSON|POISSON]] [[Documentation/SL/How_Tos/Calc: funkcija PROB|PROB]] [[Documentation/SL/How_Tos/Calc: funkcija QUARTILE|QUARTILE]] [[Documentation/SL/How_Tos/Calc: funkcija RANK|RANK]] [[Documentation/SL/How_Tos/Calc: funkcija RSQ|RSQ]] [[Documentation/SL/How_Tos/Calc: funkcija SKEW|SKEW]] [[Documentation/SL/How_Tos/Calc: funkcija SLOPE|SLOPE]] [[Documentation/SL/How_Tos/Calc: funkcija SMALL|SMALL]] [[Documentation/SL/How_Tos/Calc: funkcija STANDARDIZE|STANDARDIZE]] [[Documentation/SL/How_Tos/Calc: funkcija STDEV|STDEV]] [[Documentation/SL/How_Tos/Calc: funkcija STDEVA|STDEVA]] [[Documentation/SL/How_Tos/Calc: funkcija STDEVP|STDEVP]] [[Documentation/SL/How_Tos/Calc: funkcija STDEVPA|STDEVPA]] [[Documentation/SL/How_Tos/Calc: funkcija STEYX|STEYX]] [[Documentation/SL/How_Tos/Calc: funkcija TDIST|TDIST]] [[Documentation/SL/How_Tos/Calc: funkcija TINV|TINV]] [[Documentation/SL/How_Tos/Calc: funkcija TRIMMEAN|TRIMMEAN]] [[Documentation/SL/How_Tos/Calc: funkcija TTEST|TTEST]] [[Documentation/SL/How_Tos/Calc: funkcija VAR|VAR]] [[Documentation/SL/How_Tos/Calc: funkcija VARA|VARA]] [[Documentation/SL/How_Tos/Calc: funkcija VARP|VARP]] [[Documentation/SL/How_Tos/Calc: funkcija VARPA|VARPA]] [[Documentation/SL/How_Tos/Calc: funkcija WEIBULL|WEIBULL]] [[Documentation/SL/How_Tos/Calc: funkcija ZTEST|ZTEST]] |
'''[[Documentation/SL/How_Tos/Calc: Funkcije za preglednice|Funkcije za preglednice]]''' | '''[[Documentation/SL/How_Tos/Calc: Funkcije za preglednice|Funkcije za preglednice]]''' | ||
− | :The 'Spreadsheet' | + | :The 'Spreadsheet's find values in tables, or cell references. |
− | :[[Documentation/How_Tos/Calc: ADDRESS | + | :[[Documentation/SL/How_Tos/Calc: funkcija ADDRESS|ADDRESS]], [[Documentation/SL/How_Tos/Calc: funkcija CHOOSE|CHOOSE]], [[Documentation/SL/How_Tos/Calc: funkcija HLOOKUP|HLOOKUP]], [[Documentation/SL/How_Tos/Calc: funkcija INDEX|INDEX]], [[Documentation/SL/How_Tos/Calc: funkcija INDIRECT|INDIRECT]], [[Documentation/SL/How_Tos/Calc: funkcija LOOKUP|LOOKUP]], [[Documentation/SL/How_Tos/Calc: funkcija MATCH|MATCH]], [[Documentation/SL/How_Tos/Calc: funkcija OFFSET|OFFSET]], [[Documentation/SL/How_Tos/Calc: funkcija VLOOKUP|VLOOKUP]] |
− | :[[Documentation/How_Tos/Calc: AREAS | + | :[[Documentation/SL/How_Tos/Calc: funkcija AREAS|AREAS]], [[Documentation/SL/How_Tos/Calc: funkcija COLUMN|COLUMN]], [[Documentation/SL/How_Tos/Calc: funkcija COLUMNS|COLUMNS]], [[Documentation/SL/How_Tos/Calc: funkcija ERRORTYPE|ERRORTYPE]], [[Documentation/SL/How_Tos/Calc: funkcija INFO|INFO]], [[Documentation/SL/How_Tos/Calc: funkcija ROW|ROW]], [[Documentation/SL/How_Tos/Calc: funkcija ROWS|ROWS]], [[Documentation/SL/How_Tos/Calc: funkcija SHEET|SHEET]], [[Documentation/SL/How_Tos/Calc: funkcija SHEETS|SHEETS]] |
− | :[[Documentation/How_Tos/Calc: DDE | + | :[[Documentation/SL/How_Tos/Calc: funkcija DDE|DDE]], [[Documentation/SL/How_Tos/Calc: funkcija HYPERLINK|HYPERLINK]], [[Documentation/SL/How_Tos/Calc: funkcija STYLE|STYLE]] |
'''[[Documentation/SL/How_Tos/Calc: Besedilne funkcije|Besedilne funkcije]]''' | '''[[Documentation/SL/How_Tos/Calc: Besedilne funkcije|Besedilne funkcije]]''' | ||
− | :The | + | :The Texts manipulate or return text. |
− | :[[Documentation/How_Tos/Calc: BASE | + | :[[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]] |
Line 68: | Line 68: | ||
[[Category:Calc po slovensko]] | [[Category:Calc po slovensko]] | ||
[[Category:KakOOojčki]] | [[Category:KakOOojčki]] | ||
− | {{InterWiki | + | {{InterWiki Calcs listed by category}} |
Revision as of 15:59, 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