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

From Apache OpenOffice Wiki
Jump to: navigation, search
(→‎Funkcije programa Calc po kategorijah)
(→‎Funkcije programa Calc po kategorijah)
Line 9: Line 9:
  
 
'''[[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 Numbers operate on (mathematical) complex numbers such as 2 + 3i.
+
: Kompleksna števila delujejo na (matematičnih) kompleksnih številih, kot je 2 + 3i.
 
:[[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: 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 Databases are used to extract information from Calc data tables, where data is organised in rows.
+
:Zbirke podatkov uporabljamo za izluščanje podatkov iz podatkovnih tabel v Calcu, kjer so podatki organizirani v vrstice.
 
:[[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/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/SL/How_Tos/Calc: Datumske in časovne funkcije|Datumske in časovne funkcije]]'''
 
'''[[Documentation/SL/How_Tos/Calc: Datumske in časovne funkcije|Datumske in časovne funkcije]]'''
−
:The Date & Times are used to manipulate dates and times.
+
:Funkcije za datum in čas uporabljamo za računanje datumov in čas.
 
:[[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: 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 Financials provide common business calculations.  
+
:Finančne funkcije zagotavljajo pogoste poslovne izračune.
  
 
'''[[Documentation/SL/How_Tos/Calc: Informacijske funkcije|Informacijske funkcije]]'''
 
'''[[Documentation/SL/How_Tos/Calc: Informacijske funkcije|Informacijske funkcije]]'''
−
:The Informations return information about cells, such as whether they contain text or a formula, etc.  
+
:Informacijske funkcije vrnejo podatke o celicah, kot je to, ali vsebujejo besedilo ali formulo itn.
 
:[[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: 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 Logicals include boolean logic '''AND''', '''OR''', '''NOT'''s, ands such as '''IF''' which test a logical result.  
+
: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]]'''
−
:The Mathematicals include trigonometric, hyperbolic, logarithmic and summations.  
+
: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]]'''
−
:The Number Conversions convert numbers between forms.  
+
: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]]

Revision as of 20:27, 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

Funkcije za zbirke podatkov

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

Datumske in časovne funkcije

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

Finančne funkcije zagotavljajo pogoste poslovne izračune.

Informacijske funkcije

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

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

Matematične funkcije

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

Funkcije za pretvorbo števil

Pretvarjajo števila med različnimi pojavnimi oblikami.
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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/SL/How_Tos/Calc:_Funkcije_po_kategorijah&oldid=123456"
Personal tools