Text: CHAR, CLEAN, CODE, CONCATENATE, EXACT, FIND, LEFT, LEN, LOWER, MID, PROPER, REPLACE, REPT, RIGHT, SEARCH, SUBSTITUTE, TEXT, TRIM, UPPER, TextToColumns
Statistical: AVERAGE, AVERAGEA, COUNT, COUNTA, COUNTBLANK, COUNTIF, LARGE, MAX, MAXA, MEDIAN, MIN, MINA, RANK, SMALL
Math & Trig: ABS, INT, MOD, POWER, PRODUCT, RAND, RANDBETWEEN, ROMAN, ROUND, ROUNDDOWN, ROUNDUP, SIGN, SUBTOTAL, SUM, SUMIF, SUMPRODUCT, TRUNC
Lookup & Ref: ADDRESS, AREAS, CHOOSE, COLUMN, COLUMNS, HLOOKUP, HYPERLINK, INDEX, INDIRECT, MATCH, OFFSET, ROW, ROWS, TRANSPOSE, VLOOKUP
Logical: AND, FALSE, IF, NOT, OR, TRUE
Information: CELL, ERROR.TYPE, INFO, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISREF, ISTEXT, TYPE
Date & Time: DATE, DATEVALUE, DAY, DAYS360, EDATE, EOMONTH, HOUR, MINUTE, MONTH, NETWORKDAYS, NOW, SECOND, TIME, TIMEVALUE, TODAY, WEEKDAY, WEEKNUM, WORKDAY, YEAR, YEARFRAC, DATEDIF
Database: DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSUM
Program obuke Excel 3 Funkcije | 117 kB | Download |