합계·조건 계산
SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTBLANK, COUNTIF, SUMIF, COUNTIFS, SUMIFS, AVERAGEIF, AVERAGEIFS, MINIFS, MAXIFS
수학
ROUND, ROUNDUP, ROUNDDOWN, ABS, SIGN, INT, TRUNC, MOD, SQRT, EVEN, ODD, PI, EXP, LN, LOG, LOG10, SIN, COS, TAN, ASIN, ACOS, ATAN, ATAN2, DEGREES, RADIANS, FACT, FACTDOUBLE, COMBIN, COMBINA, PERMUT, PERMUTATIONA, GCD, LCM, MROUND, CEILING, FLOOR, CEILING.MATH, FLOOR.MATH, CEILING.PRECISE, FLOOR.PRECISE, ISO.CEILING, POWER, QUOTIENT, PRODUCT
통계
SUMSQ, AVEDEV, DEVSQ, VAR, VARP, VAR.S, VAR.P, STDEV, STDEVP, STDEV.S, STDEV.P, PERCENTILE, PERCENTILE.INC, PERCENTILE.EXC, QUARTILE, QUARTILE.INC, QUARTILE.EXC, PERCENTRANK, PERCENTRANK.INC, PERCENTRANK.EXC, MEDIAN, MODE, MODE.SNGL, LARGE, SMALL, RANK, RANK.EQ, RANK.AVG
논리·정보
IF, IFERROR, IFNA, AND, OR, NOT, XOR, IFS, SWITCH, N, T, TYPE, NA, ISBLANK, ISNUMBER, ISTEXT, ISERROR, ISNA, ISERR, ISLOGICAL, ISNONTEXT, ISEVEN, ISODD
문자·변환
LEFT, RIGHT, MID, LEN, TRIM, CLEAN, SUBSTITUTE, UPPER, LOWER, PROPER, CONCATENATE, TEXTJOIN, CONCAT, REPLACE, FIND, SEARCH, REPT, EXACT, VALUE, TEXT, NUMBERVALUE, FIXED, DOLLAR, UNICODE, UNICHAR, CHAR, CODE, TEXTBEFORE, TEXTAFTER
날짜·시간
DATE, YEAR, MONTH, DAY, TODAY, NOW, HOUR, MINUTE, SECOND, TIME, DAYS, EDATE, EOMONTH, WEEKDAY, WEEKNUM, ISOWEEKNUM, DATEDIF, YEARFRAC, WORKDAY, NETWORKDAYS, WORKDAY.INTL, NETWORKDAYS.INTL
조회·참조
VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP, ROW, COLUMN, ROWS, COLUMNS, ADDRESS, CHOOSE, LOOKUP