Excel 3 - Funkcije
Excel 3 - Funkcije

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

Download:

Excel 3 - FunkcijeProgram obuke Excel 3 Funkcije pdf117 kBDownload