[기본작업] 수학통계함수 3

수학통계함수

통계함수

AVERAGE, MAX, MIN, RANK,VAR, STDEV, COUNT, MEDIAN, MODE, AVERAGEA, LARGE, SMALL, COUNTA, COUNTBLANK. COUNTIF, GEOMEAN, HARMEAN, PERCENTILE, FREQUENCY, AVERAGEIF, AVERAGEIFS, COUNTIFS, MAXA

재무함수

FV, PV, NPV, PMT, AMORDEGRC, AMORLINC, DB, DDB, SLN, SYD

수학 및 삼각함수

SUM, ROUND, ROUNDUP, ROUNDDOWN, ABS, INT, SUMIF, RAND, MOD, FACT, SQRT, PI, EXP, POWER, TRUNC, PRODUCT, RANDBETWEEN, MDETERM, MINVERSE, MMULT, SUMPRODUCT, QUOTIENT, SIGN, SUMIFS

---