Funkcije Baze podataka
DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN,
DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP
|
|
Funkcije - Datum i vrijeme
DATE, DATEVALUE, DAY, DAYS360, EDATE, EOMONTH, HOUR,
MINUTE, MONTH, NETWORKDAYS, NOW, SECOND, TIME,
TIMEVALUE, TODAY, WEEKDAY, WEEKNUM, WORKDAY, YEAR,
YEARFRAC
|
|
Inženjerske (Tehničke) funkcije
BESSELI, BESSELJ, BESSELK, BESSELY, BIN2DEC,
BIN2HEX, BIN2OCT, COMPLEX, CONVERT, DEC2BIN,
DEC2HEX, DEC2OCT, DELTA, ERF, ERFC, GESTEP, HEX2BIN,
HEX2DEC, HEX2OCT, IMABS, IMAGINARY, IMARGUMENT,
IMCONJUGATE, IMCOS, IMDIV, IMEXP, IMLN, IMLOG10,
IMLOG2, IMPOWER, IMPRODUCT, IMREAL, IMSIN, IMSQRT,
IMSUB, IMSUM, OCT2BIN, OCT2DEC, OCT2HEX
|
Financijske funkcije
ACCRINT, ACCRINTM, AMORDEGRC, AMORLINC, COUPDAYBS,
COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD,
CUMIPMT, CUMPRINC, DB, DDB, DISC, DOLLARDE, DOLLARFR,
DURATION, EFFECT, FV, FVSCHEDULE, INTRATE, IPMT, IRR,
ISPMT, MDURATION, MIRR, NOMINAL, NPER, NPV,
ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD, PMT,
PPMT, PRICE, PRICEDISC, PRICEMAT, PV, RATE, RECEIVED,
SLN, SYD, TBILLEQ, TBILLPRICE, TBILLYIELD, VDB, XIRR,
XNPV, YIELD, YIELDDISC, YIELDMAT
|
Informacijske funkcije
CELL, ERROR.TYPE, INFO, ISBLANK, ISERR, ISERROR,
ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD,
ISREF, ISTEXT, N, NA, TYPE
|
|
Funkcije za pretraživanje i reference
ADDRESS, AREAS, CHOOSE, COLUMN, COLUMNS,
GETPIVOTDATA, HLOOKUP, HYPERLINK, INDEX, INDIRECT,
LOOKUP, MATCH, OFFSET, ROW, ROWS, RTD, TRANSPOSE,
VLOOKUP
|
Matematičke i trigonometrijske funkcije
ABS, ACOS, ACOSH, ASIN, ASINH, ATAN, ATAN2, ATANH,
CEILING, COMBIN, COS, COSH, DEGREES, EVEN, EXP, FACT,
FACTDOUBLE, FLOOR, GCD, INT, LCM, LN, LOG, LOG10,
MDETERM, MINVERSE, MMULT, MOD, MROUND, MULTINOMIAL,
ODD, PI, POWER, PRODUCT, QUOTIENT, RADIANS, RAND,
RANDBETWEEN, ROMAN, ROUND, ROUNDDOWN, ROUNDUP,
SERIESSUM, SIGN, SIN, SINH, SQRT, SQRTPI, SUBTOTAL,
SUM, SUMIF, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2,
SUMXMY2, TAN, TANH, TRUNC
|
Statističke funkcije
AVEDEV, AVERAGE, AVERAGEA, BINOMDIST, BETADIST,
BETAINV, CHIDIST, CHIINV, CHITEST, CONFIDENCE,
CORREL, COUNT, COUNTA, COUNTBLANK, COUNTIF, COVAR,
CRITBINOM, DEVSQ, EXPONDIST, FDIST, FINV, FISHER,
FISHERINV, FORECAST, FREQUENCY, FTEST, GAMMADIST,
GAMMAINV, GAMMALN, GEOMEAN, GROWTH, HARMEAN,
HYPGEOMDIST, INTERCEPT, KURT, LARGE, LINEST, LOGEST,
LOGINV, LOGNORMDIST, MAX, MAXA, MEDIAN, MIN, MINA,
MODE, NEGBINOMDIST, NORMDIST, NORMINV, NORMSDIST,
NORMSINV, PEARSON, PERCENTILE, PERCENTRANK, PERMUT,
POISSON, PROB, QUARTILE, RANK, RSQ, SKEW, SLOPE,
SMALL, STANDARDIZE, STDEV, STDEVA, STDEVP, STDEVPA,
STEYX, TDIST, TINV, TREND, TRIMMEAN, TTEST, VAR,
VARA, VARP, VARPA, WEIBULL, ZTEST
|
Tekstualne i podatkovne funkcije
ASC, BAHTTEXT, CHAR, CLEAN, CODE, CONCATENATE,
DOLLAR, EXACT, FIND, FIXED, JIS, LEFT, LEN, LOWER,
MID, PHONETIC, PROPER, REPLACE, REPT, RIGHT, SEARCH,
SUBSTITUTE, T, TEXT, TRIM, UPPER, VALUE
|
|