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

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

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