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) |
(→Funkcije programa Calc po kategorijah) |
||
| Line 28: | Line 28: | ||
'''[[Documentation/SL/How_Tos/Calc: Logične funkcije|Logične funkcije]]''' | '''[[Documentation/SL/How_Tos/Calc: Logične funkcije|Logične funkcije]]''' | ||
| − | :Logične funkcije vključujejo dvojiško logiko '''AND''' (IN), '''OR''' (ALI), '''NOT''' (NE), kot tudi '''IF''' (ČE), ki preizkušajo dvojiški rezultat. | + | :Logične funkcije vključujejo dvojiško logiko '''AND''' (IN), '''OR''' (ALI), '''NOT''' (NE), kot tudi '''IF''' (ČE), ki preizkušajo dvojiški rezultat. |
:[[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: 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]]''' | ||
| − | :Vključujejo trigonometrične, hiperbolične, logaritemske in vsotne funkcije. | + | :Vključujejo trigonometrične, hiperbolične, logaritemske in vsotne funkcije. |
:[[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/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/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/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]] | ||
| Line 41: | Line 41: | ||
'''[[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]]''' | ||
| − | :Pretvarjajo števila med različnimi pojavnimi oblikami. | + | :Pretvarjajo števila med različnimi pojavnimi oblikami. |
:[[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/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/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: 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]]''' | ||
| − | : | + | :Delujejo na matrikah in vrnejo cele tabele podatkov. |
:[[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: 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]]''' | ||
| − | : | + | :Ponujajo računanje statistike in verjetnosti. |
:[[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: 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]]''' | ||
| − | : | + | :Iščejo vrednosti v tabelah ali sklicih na celice. |
:[[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/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/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/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]] | ||
| Line 60: | Line 60: | ||
'''[[Documentation/SL/How_Tos/Calc: Besedilne funkcije|Besedilne funkcije]]''' | '''[[Documentation/SL/How_Tos/Calc: Besedilne funkcije|Besedilne funkcije]]''' | ||
| − | :The Texts manipulate or return text. | + | :The Texts manipulate or return text. |
:[[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]] | ||
Revision as of 20:38, 6 May 2009
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.
Lahko
- krmarite neposredno nanje s ste strani ali
- izberete kategorijo, tako dobite enovrstičen opis vsake in nekaj dodatnih pojasnil o kategoriji.
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
