Difference between revisions of "Documentation/SL/How Tos/Calc: Funkcije po kategorijah"

From Apache OpenOffice Wiki
Jump to: navigation, search
(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 Function Help for Calc. Not all functions 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.
  
 
You may
 
You may
*navigate directly to the functions from this page, or
+
*navigate directly to thes from this page, or
*select a function category, to find a one line description of each function and some explanatory notes on the category.
+
*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 Number functions operate on (mathematical) complex numbers such as 2 + 3i.
+
: The Complex Numbers operate on (mathematical) complex numbers such as 2 + 3i.
:[[Documentation/How_Tos/Calc: COMPLEX function|COMPLEX]], [[Documentation/How_Tos/Calc: IMABS function|IMABS]], [[Documentation/How_Tos/Calc: IMAGINARY function|IMAGINARY]], [[Documentation/How_Tos/Calc: IMPOWER function|IMPOWER]], [[Documentation/How_Tos/Calc: IMARGUMENT function|IMARGUMENT]], [[Documentation/How_Tos/Calc: IMCOS function|IMCOS]], [[Documentation/How_Tos/Calc: IMDIV function|IMDIV]], [[Documentation/How_Tos/Calc: IMEXP function|IMEXP]], [[Documentation/How_Tos/Calc: IMCONJUGATE function|IMCONJUGATE]], [[Documentation/How_Tos/Calc: IMLN function|IMLN]], [[Documentation/How_Tos/Calc: IMLOG10 function|IMLOG10]], [[Documentation/How_Tos/Calc: IMLOG2 function|IMLOG2]], [[Documentation/How_Tos/Calc: IMPRODUCT function|IMPRODUCT]], [[Documentation/How_Tos/Calc: IMREAL function|IMREAL]], [[Documentation/How_Tos/Calc: IMSIN function|IMSIN]], [[Documentation/How_Tos/Calc: IMSUB function|IMSUB]], [[Documentation/How_Tos/Calc: IMSUM function|IMSUM]], [[Documentation/How_Tos/Calc: IMSQRT function|IMSQRT]]
+
:[[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 Database functions are used to extract information from Calc data tables, where data is organised in rows.
+
:The Databases are used to extract information from Calc data tables, where data is organised in rows.
:[[Documentation/How_Tos/Calc: DCOUNT function|DCOUNT]], [[Documentation/How_Tos/Calc: DCOUNTA function|DCOUNTA]], [[Documentation/How_Tos/Calc: DGET function|DGET]], [[Documentation/How_Tos/Calc: DMAX function|DMAX]], [[Documentation/How_Tos/Calc: DMIN function|DMIN]], [[Documentation/How_Tos/Calc: DAVERAGE function|DAVERAGE]], [[Documentation/How_Tos/Calc: DPRODUCT function|DPRODUCT]], [[Documentation/How_Tos/Calc: DSTDEV function|DSTDEV]], [[Documentation/How_Tos/Calc: DSTDEVP function|DSTDEVP]], [[Documentation/How_Tos/Calc: DSUM function|DSUM]], [[Documentation/How_Tos/Calc: DVAR function|DVAR]], [[Documentation/How_Tos/Calc: DVARP function|DVARP]]
+
:[[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: Date & Time functions|Date & Time functions]]'''
+
'''[[Documentation/SL/How_Tos/Calc: Datumske in časovne funkcije|Datumske in časovne funkcije]]'''
:The Date & Time functions are used to manipulate dates and times.
+
:The Date & Times are used to manipulate dates and times.
:[[Documentation/How_Tos/Calc: TODAY function|TODAY]], [[Documentation/How_Tos/Calc: NOW function|NOW]], [[Documentation/How_Tos/Calc: YEAR function|YEAR]], [[Documentation/How_Tos/Calc: MONTH function|MONTH]], [[Documentation/How_Tos/Calc: DAY function|DAY]], [[Documentation/How_Tos/Calc: WEEKDAY function|WEEKDAY]], [[Documentation/How_Tos/Calc: HOUR function|HOUR]], [[Documentation/How_Tos/Calc: MINUTE function|MINUTE]], [[Documentation/How_Tos/Calc: SECOND function|SECOND]], [[Documentation/How_Tos/Calc: DATE function|DATE]], [[Documentation/How_Tos/Calc: DATEVALUE function|DATEVALUE]], [[Documentation/How_Tos/Calc: TIME function|TIME]], [[Documentation/How_Tos/Calc: TIMEVALUE function|TIMEVALUE]], [[Documentation/How_Tos/Calc: EOMONTH function|EOMONTH]], [[Documentation/How_Tos/Calc: EDATE function|EDATE]], [[Documentation/How_Tos/Calc: WORKDAY function|WORKDAY]], [[Documentation/How_Tos/Calc: NETWORKDAYS function|NETWORKDAYS]], [[Documentation/How_Tos/Calc: DAYS function|DAYS]], [[Documentation/How_Tos/Calc: DAYS360 function|DAYS360]], [[Documentation/How_Tos/Calc: DAYSINMONTH function|DAYSINMONTH]], [[Documentation/How_Tos/Calc: DAYSINYEAR function|DAYSINYEAR]], [[Documentation/How_Tos/Calc: WEEKS function|WEEKS]], [[Documentation/How_Tos/Calc: WEEKSINYEAR function|WEEKSINYEAR]], [[Documentation/How_Tos/Calc: WEEKNUM function|WEEKNUM]], [[Documentation/How_Tos/Calc: WEEKNUM_ADD function|WEEKNUM_ADD]], [[Documentation/How_Tos/Calc: MONTHS function|MONTHS]], [[Documentation/How_Tos/Calc: YEARS function|YEARS]], [[Documentation/How_Tos/Calc: ISLEAPYEAR function|ISLEAPYEAR]], [[Documentation/How_Tos/Calc: EASTERSUNDAY function|EASTERSUNDAY]], [[Documentation/How_Tos/Calc: YEARFRAC function|YEARFRAC]]
+
:[[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 Financial functions provide common business calculations.  
+
: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 Information functions return information about cells, such as whether they contain text or a formula, etc.  
+
:The Informations return information about cells, such as whether they contain text or a formula, etc.  
:[[Documentation/How_Tos/Calc: CELL function|CELL]], [[Documentation/How_Tos/Calc: CURRENT function|CURRENT]], [[Documentation/How_Tos/Calc: FORMULA function|FORMULA]], [[Documentation/How_Tos/Calc: ISBLANK function|ISBLANK]], [[Documentation/How_Tos/Calc: ISERR function|ISERR]], [[Documentation/How_Tos/Calc: ISERROR function|ISERROR]], [[Documentation/How_Tos/Calc: ISEVEN function|ISEVEN]], [[Documentation/How_Tos/Calc: ISEVEN_ADD function|ISEVEN_ADD]], [[Documentation/How_Tos/Calc: ISFORMULA function|ISFORMULA]], [[Documentation/How_Tos/Calc: ISLOGICAL function|ISLOGICAL]], [[Documentation/How_Tos/Calc: ISNA function|ISNA]], [[Documentation/How_Tos/Calc: ISNONTEXT function|ISNONTEXT]], [[Documentation/How_Tos/Calc: ISNUMBER function|ISNUMBER]], [[Documentation/How_Tos/Calc: ISODD function|ISODD]], [[Documentation/How_Tos/Calc: ISODD_ADD function|ISODD_ADD]], [[Documentation/How_Tos/Calc: ISREF function|ISREF]], [[Documentation/How_Tos/Calc: ISTEXT function|ISTEXT]], [[Documentation/How_Tos/Calc: N function|N]], [[Documentation/How_Tos/Calc: NA function|NA]], [[Documentation/How_Tos/Calc: TYPE function|TYPE]]  
+
:[[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 Logical functions include boolean logic '''AND''', '''OR''', '''NOT''' functions, and functions such as '''IF''' which test a logical result.  
+
:The Logicals include boolean logic '''AND''', '''OR''', '''NOT'''s, ands such as '''IF''' which test a logical result.  
:[[Documentation/How_Tos/Calc: AND function|AND]], [[Documentation/How_Tos/Calc: FALSE function|FALSE]], [[Documentation/How_Tos/Calc: IF function|IF]], [[Documentation/How_Tos/Calc: NOT function|NOT]], [[Documentation/How_Tos/Calc: OR function|OR]], [[Documentation/How_Tos/Calc: TRUE function|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]]'''
:The Mathematical functions include trigonometric, hyperbolic, logarithmic and summation functions.  
+
:The Mathematicals include trigonometric, hyperbolic, logarithmic and summations.  
:[[Documentation/How_Tos/Calc: COS function|COS]], [[Documentation/How_Tos/Calc: SIN function|SIN]], [[Documentation/How_Tos/Calc: TAN function|TAN]], [[Documentation/How_Tos/Calc: COT function|COT]], [[Documentation/How_Tos/Calc: ACOS function|ACOS]], [[Documentation/How_Tos/Calc: ACOT function|ACOT]], [[Documentation/How_Tos/Calc: ASIN function|ASIN]], [[Documentation/How_Tos/Calc: ATAN function|ATAN]], [[Documentation/How_Tos/Calc: ATAN2 function|ATAN2]], [[Documentation/How_Tos/Calc: DEGREES function|DEGREES]], [[Documentation/How_Tos/Calc: RADIANS function|RADIANS]], [[Documentation/How_Tos/Calc: PI function|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/How_Tos/Calc: COSH function|COSH]], [[Documentation/How_Tos/Calc: SINH function|SINH]], [[Documentation/How_Tos/Calc: TANH function|TANH]], [[Documentation/How_Tos/Calc: COTH function|COTH]], [[Documentation/How_Tos/Calc: ACOSH function|ACOSH]], [[Documentation/How_Tos/Calc: ACOTH function|ACOTH]], [[Documentation/How_Tos/Calc: ASINH function|ASINH]], [[Documentation/How_Tos/Calc: ATANH function|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]]  
:[[Documentation/How_Tos/Calc: TRUNC function|TRUNC]], [[Documentation/How_Tos/Calc: ROUND function|ROUND]], [[Documentation/How_Tos/Calc: ROUNDDOWN function|ROUNDDOWN]], [[Documentation/How_Tos/Calc: ROUNDUP function|ROUNDUP]], [[Documentation/How_Tos/Calc: CEILING function|CEILING]], [[Documentation/How_Tos/Calc: FLOOR function|FLOOR]], [[Documentation/How_Tos/Calc: EVEN function|EVEN]], [[Documentation/How_Tos/Calc: ODD function|ODD]], [[Documentation/How_Tos/Calc: MROUND function|MROUND]], [[Documentation/How_Tos/Calc: INT function|INT]], [[Documentation/How_Tos/Calc: QUOTIENT function|QUOTIENT]], [[Documentation/How_Tos/Calc: MOD function|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/How_Tos/Calc: EXP function|EXP]], [[Documentation/How_Tos/Calc: POWER function|POWER]], [[Documentation/How_Tos/Calc: LOG function|LOG]], [[Documentation/How_Tos/Calc: LN function|LN]], [[Documentation/How_Tos/Calc: LOG10 function|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/How_Tos/Calc: ABS function|ABS]], [[Documentation/How_Tos/Calc: COMBIN function|COMBIN]], [[Documentation/How_Tos/Calc: COMBINA function|COMBINA]], [[Documentation/How_Tos/Calc: CONVERT function|CONVERT]], [[Documentation/How_Tos/Calc: CONVERT_ADD function|CONVERT_ADD]], [[Documentation/How_Tos/Calc: COUNTBLANK function|COUNTBLANK]], [[Documentation/How_Tos/Calc: COUNTIF function|COUNTIF]], [[Documentation/How_Tos/Calc: DELTA function|DELTA]], [[Documentation/How_Tos/Calc: ERF function|ERF]], [[Documentation/How_Tos/Calc: ERFC function|ERFC]], [[Documentation/How_Tos/Calc: FACT function|FACT]], [[Documentation/How_Tos/Calc: FACTDOUBLE function|FACTDOUBLE]], [[Documentation/How_Tos/Calc: GCD function|GCD]], [[Documentation/How_Tos/Calc: GCD_ADD function|GCD_ADD]], [[Documentation/How_Tos/Calc: GESTEP function|GESTEP]], [[Documentation/How_Tos/Calc: ISEVEN function|ISEVEN]], [[Documentation/How_Tos/Calc: ISODD function|ISODD]], [[Documentation/How_Tos/Calc: LCM function|LCM]], [[Documentation/How_Tos/Calc: LCM_ADD function|LCM_ADD]], [[Documentation/How_Tos/Calc: MULTINOMIAL function|MULTINOMIAL]], [[Documentation/How_Tos/Calc: PRODUCT function|PRODUCT]], [[Documentation/How_Tos/Calc: RAND function|RAND]], [[Documentation/How_Tos/Calc: RANDBETWEEN function|RANDBETWEEN]], [[Documentation/How_Tos/Calc: SERIESSUM function|SERIESSUM]], [[Documentation/How_Tos/Calc: SIGN function|SIGN]], [[Documentation/How_Tos/Calc: SQRT function|SQRT]], [[Documentation/How_Tos/Calc: SQRTPI function|SQRTPI]], [[Documentation/How_Tos/Calc: SUBTOTAL function|SUBTOTAL]], [[Documentation/How_Tos/Calc: SUM function|SUM]], [[Documentation/How_Tos/Calc: SUMIF function|SUMIF]], [[Documentation/How_Tos/Calc: SUMSQ function|SUMSQ]]
+
:[[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 function|BESSELI]], [[Documentation/How_Tos/Calc: BESSELJ function|BESSELJ]], [[Documentation/How_Tos/Calc: BESSELK function|BESSELK]], [[Documentation/How_Tos/Calc: BESSELY function|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]]
  
 
'''[[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 Conversion functions convert numbers between forms.  
+
:The Number Conversions 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/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 function|ARABIC]], [[Documentation/How_Tos/Calc: BAHTTEXT function|BAHTTEXT]], [[Documentation/How_Tos/Calc: DECIMAL function|DECIMAL]], [[Documentation/How_Tos/Calc: ROMAN function|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]]'''
:The Array functions operate on and return entire tables of data.  
+
:The Arrays operate on and return entire tables of data.  
:[[Documentation/How_Tos/Calc: FREQUENCY function|FREQUENCY]], [[Documentation/How_Tos/Calc: GROWTH function|GROWTH]], [[Documentation/How_Tos/Calc: LINEST function|LINEST]], [[Documentation/How_Tos/Calc: LOGEST function|LOGEST]], [[Documentation/How_Tos/Calc: MDETERM function|MDETERM]], [[Documentation/How_Tos/Calc: MINVERSE function|MINVERSE]], [[Documentation/How_Tos/Calc: MMULT function|MMULT]], [[Documentation/How_Tos/Calc: MUNIT function|MUNIT]], [[Documentation/How_Tos/Calc: SUMPRODUCT function|SUMPRODUCT]], [[Documentation/How_Tos/Calc: SUMX2MY2 function|SUMX2MY2]], [[Documentation/How_Tos/Calc: SUMX2PY2 function|SUMX2PY2]], [[Documentation/How_Tos/Calc: SUMXMY2 function|SUMXMY2]], [[Documentation/How_Tos/Calc: TRANSPOSE function|TRANSPOSE]], [[Documentation/How_Tos/Calc: TREND function|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]]'''
:The Statistical functions provide statistical and probability calculations.
+
:The Statisticals provide statistical and probability calculations.
:[[Documentation/How_Tos/Calc: AVEDEV function|AVEDEV]] [[Documentation/How_Tos/Calc: AVERAGE function|AVERAGE]] [[Documentation/How_Tos/Calc: AVERAGEA function|AVERAGEA]] [[Documentation/How_Tos/Calc: B function|B]] [[Documentation/How_Tos/Calc: BETADIST function|BETADIST]] [[Documentation/How_Tos/Calc: BETAINV function|BETAINV]] [[Documentation/How_Tos/Calc: BINOMDIST function|BINOMDIST]] [[Documentation/How_Tos/Calc: COUNT function|COUNT]] [[Documentation/How_Tos/Calc: COUNTA function|COUNTA]] [[Documentation/How_Tos/Calc: CHIDIST function|CHIDIST]] [[Documentation/How_Tos/Calc: CHIINV function|CHIINV]] [[Documentation/How_Tos/Calc: CHITEST function|CHITEST]] [[Documentation/How_Tos/Calc: CONFIDENCE function|CONFIDENCE]] [[Documentation/How_Tos/Calc: CORREL function|CORREL]] [[Documentation/How_Tos/Calc: COVAR function|COVAR]] [[Documentation/How_Tos/Calc: CRITBINOM function|CRITBINOM]] [[Documentation/How_Tos/Calc: DEVSQ function|DEVSQ]] [[Documentation/How_Tos/Calc: EXPONDIST function|EXPONDIST]] [[Documentation/How_Tos/Calc: FINV function|FINV]] [[Documentation/How_Tos/Calc: FISHER function|FISHER]] [[Documentation/How_Tos/Calc: FISHERINV function|FISHERINV]] [[Documentation/How_Tos/Calc: FDIST function|FDIST]] [[Documentation/How_Tos/Calc: FORECAST function|FORECAST]] [[Documentation/How_Tos/Calc: FTEST function|FTEST]] [[Documentation/How_Tos/Calc: GAMMAINV function|GAMMAINV]] [[Documentation/How_Tos/Calc: GAMMALN function|GAMMALN]] [[Documentation/How_Tos/Calc: GAMMADIST function|GAMMADIST]] [[Documentation/How_Tos/Calc: GAUSS function|GAUSS]] [[Documentation/How_Tos/Calc: GEOMEAN function|GEOMEAN]] [[Documentation/How_Tos/Calc: HARMEAN function|HARMEAN]] [[Documentation/How_Tos/Calc: HYPGEOMDIST function|HYPGEOMDIST]] [[Documentation/How_Tos/Calc: INTERCEPT function|INTERCEPT]] [[Documentation/How_Tos/Calc: KURT function|KURT]] [[Documentation/How_Tos/Calc: LARGE function|LARGE]] [[Documentation/How_Tos/Calc: LOGINV function|LOGINV]] [[Documentation/How_Tos/Calc: LOGNORMDIST function|LOGNORMDIST]] [[Documentation/How_Tos/Calc: MAX function|MAX]] [[Documentation/How_Tos/Calc: MAXA function|MAXA]] [[Documentation/How_Tos/Calc: MEDIAN function|MEDIAN]] [[Documentation/How_Tos/Calc: MIN function|MIN]] [[Documentation/How_Tos/Calc: MINA function|MINA]] [[Documentation/How_Tos/Calc: MODE function|MODE]] [[Documentation/How_Tos/Calc: NEGBINOMDIST function|NEGBINOMDIST]] [[Documentation/How_Tos/Calc: NORMINV function|NORMINV]] [[Documentation/How_Tos/Calc: NORMDIST function|NORMDIST]] [[Documentation/How_Tos/Calc: NORMSINV function|NORMSINV]] [[Documentation/How_Tos/Calc: NORMSDIST function|NORMSDIST]] [[Documentation/How_Tos/Calc: PEARSON function|PEARSON]] [[Documentation/How_Tos/Calc: PERCENTILE function|PERCENTILE]] [[Documentation/How_Tos/Calc: PERCENTRANK function|PERCENTRANK]] [[Documentation/How_Tos/Calc: PERMUT function|PERMUT]] [[Documentation/How_Tos/Calc: PERMUTATIONA function|PERMUTATIONA]] [[Documentation/How_Tos/Calc: PHI function|PHI]] [[Documentation/How_Tos/Calc: POISSON function|POISSON]] [[Documentation/How_Tos/Calc: PROB function|PROB]] [[Documentation/How_Tos/Calc: QUARTILE function|QUARTILE]] [[Documentation/How_Tos/Calc: RANK function|RANK]] [[Documentation/How_Tos/Calc: RSQ function|RSQ]] [[Documentation/How_Tos/Calc: SKEW function|SKEW]] [[Documentation/How_Tos/Calc: SLOPE function|SLOPE]] [[Documentation/How_Tos/Calc: SMALL function|SMALL]] [[Documentation/How_Tos/Calc: STANDARDIZE function|STANDARDIZE]] [[Documentation/How_Tos/Calc: STDEV function|STDEV]] [[Documentation/How_Tos/Calc: STDEVA function|STDEVA]] [[Documentation/How_Tos/Calc: STDEVP function|STDEVP]] [[Documentation/How_Tos/Calc: STDEVPA function|STDEVPA]] [[Documentation/How_Tos/Calc: STEYX function|STEYX]] [[Documentation/How_Tos/Calc: TDIST function|TDIST]] [[Documentation/How_Tos/Calc: TINV function|TINV]] [[Documentation/How_Tos/Calc: TRIMMEAN function|TRIMMEAN]] [[Documentation/How_Tos/Calc: TTEST function|TTEST]] [[Documentation/How_Tos/Calc: VAR function|VAR]] [[Documentation/How_Tos/Calc: VARA function|VARA]] [[Documentation/How_Tos/Calc: VARP function|VARP]] [[Documentation/How_Tos/Calc: VARPA function|VARPA]] [[Documentation/How_Tos/Calc: WEIBULL function|WEIBULL]] [[Documentation/How_Tos/Calc: ZTEST function|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]]'''
:The 'Spreadsheet' functions find values in tables, or cell references.
+
:The 'Spreadsheet's find values in tables, or cell references.
:[[Documentation/How_Tos/Calc: ADDRESS function|ADDRESS]], [[Documentation/How_Tos/Calc: CHOOSE function|CHOOSE]], [[Documentation/How_Tos/Calc: HLOOKUP function|HLOOKUP]], [[Documentation/How_Tos/Calc: INDEX function|INDEX]], [[Documentation/How_Tos/Calc: INDIRECT function|INDIRECT]], [[Documentation/How_Tos/Calc: LOOKUP function|LOOKUP]], [[Documentation/How_Tos/Calc: MATCH function|MATCH]], [[Documentation/How_Tos/Calc: OFFSET function|OFFSET]], [[Documentation/How_Tos/Calc: VLOOKUP function|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/How_Tos/Calc: AREAS function|AREAS]], [[Documentation/How_Tos/Calc: COLUMN function|COLUMN]], [[Documentation/How_Tos/Calc: COLUMNS function|COLUMNS]], [[Documentation/How_Tos/Calc: ERRORTYPE function|ERRORTYPE]], [[Documentation/How_Tos/Calc: INFO function|INFO]], [[Documentation/How_Tos/Calc: ROW function|ROW]], [[Documentation/How_Tos/Calc: ROWS function|ROWS]], [[Documentation/How_Tos/Calc: SHEET function|SHEET]], [[Documentation/How_Tos/Calc: SHEETS function|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]]  
:[[Documentation/How_Tos/Calc:  DDE function|DDE]], [[Documentation/How_Tos/Calc: HYPERLINK function|HYPERLINK]], [[Documentation/How_Tos/Calc: STYLE function|STYLE]]  
+
:[[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 Text functions manipulate or return text.  
+
:The Texts 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]]
+
:[[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 Calc Functions listed by category}}
+
{{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

Funkcije za zbirke podatkov

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

Datumske in časovne funkcije

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

Finančne funkcije

The Financials provide common business calculations.

Informacijske funkcije

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

Logične funkcije

The Logicals include boolean logic AND, OR, NOTs, ands such as IF which test a logical result.
AND, FALSE, IF, NOT, OR, TRUE

Matematične funkcije

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

Funkcije za pretvorbo števil

The Number Conversions convert numbers between forms.
BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX
ARABIC, BAHTTEXT, DECIMAL, ROMAN

Matrične funkcije

The Arrays operate on and return entire tables of data.
FREQUENCY, GROWTH, LINEST, LOGEST, MDETERM, MINVERSE, MMULT, MUNIT, SUMPRODUCT, SUMX2MY2, SUMX2PY2, SUMXMY2, TRANSPOSE, TREND

Statistične funkcije

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

Funkcije za preglednice

The 'Spreadsheet's find values in tables, or cell references.
ADDRESS, CHOOSE, HLOOKUP, INDEX, INDIRECT, LOOKUP, MATCH, OFFSET, VLOOKUP
AREAS, COLUMN, COLUMNS, ERRORTYPE, INFO, ROW, ROWS, SHEET, SHEETS
DDE, HYPERLINK, STYLE

Besedilne funkcije

The Texts manipulate or return text.
BASE, CHAR, CLEAN, CODE, CONCATENATE, DOLLAR, EXACT, FIND, FIXED, LEFT, LEN, LOWER, MID, PROPER, REPLACE, REPT, RIGHT, SEARCH, SUBSTITUTE, T, TEXT, TRIM, UPPER, VALUETemplate:InterWiki Calcs listed by category
Personal tools