엑셀 함수 및 인수 총정리

ABS(number)
ACCRINT(issue,first_interest,settlement,rate,par,frequency,basis,calc_method)
ACCRINTM(issue,settlement,rate,par,basis)
ACOS(number)
ACOSH(number)
ACOT(number)
ACOTH(number)
AGGREGATE(function_num,options,array,k)
ADDRESS(row_num,column_num,abs_num,A1,sheet_text)
AMORDEGRC(cost,date_purchased,first_period,salvage,period,rate,basis)
AMORLINC(cost,date_purchased,first_period,salvage,period,rate,basis)
AND(logical1,logical2)
ARABIC(text)
AREAS(reference)
ARRAYTOTEXT(array,format)
ASC(text)
ASIN(number)
ASINH(number)
ATAN(number)
ATAN2(x_num,y_num)
ATANH(number)
AVEDEV(number1,number2)
AVERAGE(number1,number2)
AVERAGEA(value1,value2)
AVERAGEIF(range,criteria,average_range)
AVERAGEIFS(average_range,criteria_range,criteria)
BAHTTEXT(number)
BASE(number,radix,min_length)
BESSELI(x,n)
BESSELJ(x,n)
BESSELK(x,n)
BESSELY(x,n)
BETADIST(x,alpha,beta,A,B)
BETA.DIST(x,alpha,beta,cumulative,A,B)
BETAINV(probability,alpha,beta,A,B)
BETA.INV(probability,alpha,beta,A,B)
BIN2DEC(number)
BIN2HEX(number,places)
BIN2OCT(number,places)
BINOMDIST(number_s,trials,probability_s,cumulative)
BINOM.DIST(number_s,trials,probability_s,cumulative)
BINOM.DIST.RANGE(trials,probability_s,number_s,number_s2)
BINOM.INV(trials,probability_s,alpha)
BITAND(number1,number2)
BITLSHIFT(number,shift_amount)
BITOR(number1,number2)
BITRSHIFT(number,shift_amount)
BITXOR(number1,number2)
BYCOL(array,function)
BYROW(array,function)
CALL(
CEILING(number,significance)
CEILING.MATH(number,significance,mode)
CEILING.PRECISE(number,significance)
CELL(info_type,reference)
CHAR(number)
CHIDIST(x,deg_freedom)
CHIINV(probability,deg_freedom)
CHITEST(actual_range,expected_range)
CHISQ.DIST(x,deg_freedom,cumulative)
CHISQ.DIST.RT(x,deg_freedom)
CHISQ.INV(probability,deg_freedom)
CHISQ.INV.RT(probability,deg_freedom)
CHISQ.TEST(actual_range,expected_range)
CHOOSE(index_num,value1,value2)
CHOOSECOLS(array,col_num1,col_num2)
CHOOSEROWS(array,row_num1,row_num2)
CLEAN(text)
CODE(text)
COLUMN(reference)
COLUMNS(array)
COMBIN(number,number_chosen)
COMBINA(number,number_chosen)
COMPLEX(real_num,i_num,suffix)
CONCAT(text1)
CONCATENATE(text1,text2)
CONFIDENCE(alpha,standard_dev,size)
CONFIDENCE.NORM(alpha,standard_dev,size)
CONFIDENCE.T(alpha,standard_dev,size)
CONVERT(number,from_unit,to_unit)
CORREL(array1,array2)
COS(number)
COSH(number)
COT(number)
COTH(number)
COUNT(value1,value2)
COUNTA(value1,value2)
COUNTBLANK(range)
COUNTIF(range,criteria)
COUNTIFS(criteria_range,criteria)
COUPDAYBS(settlement,maturity,frequency,basis)
COUPDAYS(settlement,maturity,frequency,basis)
COUPDAYSNC(settlement,maturity,frequency,basis)
COUPNCD(settlement,maturity,frequency,basis)
COUPNUM(settlement,maturity,frequency,basis)
COUPPCD(settlement,maturity,frequency,basis)
COVAR(array1,array2)
COVARIANCE.P(array1,array2)
COVARIANCE.S(array1,array2)
CRITBINOM(trials,probability_s,alpha)
CSC(number)
CSCH(number)
CUBEKPIMEMBER(connection,kpi_name,kpi_property,caption)
CUBEMEMBER(connection,member_expression,caption)
CUBEMEMBERPROPERTY(connection,member_expression,property)
CUBERANKEDMEMBER(connection,set_expression,rank,caption)
CUBESET(connection,set_expression,caption,sort_order,sort_by)
CUBESETCOUNT(set)
CUBEVALUE(connection,member_expression1)
CUMIPMT(rate,nper,pv,start_period,end_period,type)
CUMPRINC(rate,nper,pv,start_period,end_period,type)
DATE(year,month,day)
DATEDIF(
DATEVALUE(date_text)
DAVERAGE(database,field,criteria)
DAY(serial_number)
DAYS(end_date,start_date)
DAYS360(start_date,end_date,method)
DB(cost,salvage,life,period,month)
DBCS()
DCOUNT(database,field,criteria)
DCOUNTA(database,field,criteria)
DDB(cost,salvage,life,period,factor)
DEC2BIN(number,places)
DEC2HEX(number,places)
DEC2OCT(number,places)
DECIMAL(number,radix)
DEGREES(angle)
DELTA(number1,number2)
DEVSQ(number1,number2)
DGET(database,field,criteria)
DISC(settlement,maturity,pr,redemption,basis)
DMAX(database,field,criteria)
DMIN(database,field,criteria)
DOLLAR(number,decimals)
DOLLARDE(fractional_dollar,fraction)
DOLLARFR(decimal_dollar,fraction)
DPRODUCT(database,field,criteria)
DROP(array,rows,columns)
DSTDEV(database,field,criteria)
DSTDEVP(database,field,criteria)
DSUM(database,field,criteria)
DURATION(settlement,maturity,coupon,yld,frequency,basis)
DVAR(database,field,criteria)
DVARP(database,field,criteria)
EDATE(start_date,months)
EFFECT(nominal_rate,npery)
ENCODEURL(text)
EOMONTH(start_date,months)
ERF(lower_limit,upper_limit)
ERF.PRECISE(x)
ERFC(x)
ERFC.PRECISE(x)
ERROR.TYPE(error_val)
EUROCONVERT()
EVEN(number)
EXACT(text1,text2)
EXP(number)
EXPAND(array,rows,columns,pad_with)
EXPON.DIST(x,lambda,cumulative)
EXPONDIST(x,lambda,cumulative)
FACT(number)
FACTDOUBLE(number)
FALSE()
F.DIST(x,deg_freedom1,deg_freedom2,cumulative)
FDIST(x,deg_freedom1,deg_freedom2)
F.DIST.RT(x,deg_freedom1,deg_freedom2)
FILTER(배열,포함,if_empty)
FILTERXML(xml,xpath)
FIND(find_text,within_text,start_num)
F.INV(probability,deg_freedom1,deg_freedom2)
F.INV.RT(probability,deg_freedom1,deg_freedom2)
FINV(probability,deg_freedom1,deg_freedom2)
FISHER(x)
FISHERINV(y)
FIXED(number,decimals,no_commas)
FLOOR(number,significance)
FLOOR.MATH(number,significance,mode)
FLOOR.PRECISE(number,significance)
FORECAST(x,knownys,knownxs)
FORECAST.ETS(target_date,values,timeline,seasonality,data_completion,aggregation)
FORECAST.ETS.CONFINT(target_date,values,timeline,confidence_level,seasonality,data_completion,aggregation)
FORECAST.ETS.SEASONALITY(values,timeline,data_completion,aggregation)
FORECAST.ETS.STAT(values,timeline,statistic_type,seasonality,data_completion,aggregation)
FORECAST.LINEAR(x,knownys,knownxs)
FORMULATEXT(reference)
FREQUENCY(data_array,bins_array)
F.TEST(array1,array2)
FTEST(array1,array2)
FV(rate,nper,pmt,pv,type)
FVSCHEDULE(principal,schedule)
GAMMA(x)
GAMMA.DIST(x,alpha,beta,cumulative)
GAMMADIST(x,alpha,beta,cumulative)
GAMMA.INV(probability,alpha,beta)
GAMMAINV(probability,alpha,beta)
GAMMALN(x)
GAMMALN.PRECISE(x)
GAUSS(x)
GCD(number1,number2)
GEOMEAN(number1,number2)
GESTEP(number,step)
GETPIVOTDATA(data_field,pivot_table,field,item)
GROWTH(knownys,known_xs,new_xs,const)
HARMEAN(number1,number2)
HEX2BIN(number,places)
HEX2DEC(number)
HEX2OCT(number,places)
HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)
HOUR(serial_number)
HSTACK(array1,array2)
HYPERLINK(Link_location,friendly_name)
HYPGEOM.DIST(sample_s,number_sample,population_s,number_pop,cumulative)
HYPGEOMDIST(sample_s,number_sample,population_s,number_pop)
IF(logical_test,value_if_true,value_if_false)
IFERROR(value,value_if_error)
IFNA(value,value_if_na)
IFS(logical_test,value_if_true)
IMABS(inumber)
IMAGINARY(inumber)
IMARGUMENT(inumber)
IMCONJUGATE(inumber)
IMCOS(inumber)
IMCOSH(inumber)
IMCOT(inumber)
IMCSC(inumber)
IMCSCH(inumber)
IMDIV(inumber1,inumber2)
IMEXP(inumber)
IMLN(inumber)
IMLOG10(inumber)
IMLOG2(inumber)
IMPOWER(inumber,number)
IMPRODUCT(inumber1,inumber2)
IMREAL(inumber)
IMSEC(inumber)
IMSECH(inumber)
IMSIN(inumber)
IMSINH(inumber)
IMSQRT(inumber)
IMSUB(inumber1,inumber2)
IMSUM(inumber1,inumber2)
IMTAN(inumber)
INDEX(array,row_num,column_num)
INDIRECT(ref_text,A1)
INFO(type_text)
INT(number)
INTERCEPT(knownys,knownxs)
INTRATE(settlement,maturity,investment,redemption,basis)
IPMT(rate,per,nper,pv,fv,type)
IRR(values,guess)
ISBLANK(value)
ISERR(value)
ISERROR(value)
ISEVEN(number)
ISFORMULA(reference)
ISLOGICAL(value)
ISNA(value)
ISNONTEXT(value)
ISNUMBER(value)
ISODD(number)
ISOMITTED(argument)
ISREF(value)
ISTEXT(value)
ISO.CEILING(number,significance)
ISOWEEKNUM(date)
ISPMT(rate,per,nper,pv)
JIS()
KURT(number1,number2)
LAMBDA(parameter_or_calculation)
LARGE(array,k)
LCM(number1,number2)
LEFT.LEFTB()
LEN.LENB()
LET(이름1,이름_값1,계산_또는_이름2)
LINEST(known_ys,known_xs,const,stats)
LN(number)
LOG(number,base)
LOG10(number)
LOGEST(known_ys,known_xs,const,stats)
LOGINV(probability,mean,standard_dev)
LOGNORM.DIST(x,mean,standard_dev,cumulative)
LOGNORMDIST(x,mean,standard_dev)
LOGNORM.INV(probability,mean,standard_dev)
LOOKUP(lookup_value,lookup_vector,result_vector)
LOWER(text)
MAKEARRAY(rows,columns,function)
MAP(array,lambda_or_array2)
MATCH(lookup_value,lookup_array,match_type)
MAX(number1,number2)
MAXA(value1,value2)
MAXIFS(max_range,criteria_range,criteria)
MDETERM(array)
MDURATION(settlement,maturity,coupon,yld,frequency,basis)
MEDIAN(number1,number2)
MID.MIDB()
MIN(number1,number2)
MINIFS(min_range,criteria_range,criteria)
MINA(value1,value2)
MINUTE(serial_number)
MINVERSE(array)
MIRR(values,finance_rate,reinvest_rate)
MMULT(array1,array2)
MOD(number,divisor)
MODE(number1,number2)
MODE.MULT(number1,number2)
MODE.SNGL(number1,number2)
MONTH(serial_number)
MROUND(number,multiple)
MULTINOMIAL(number1,number2)
MUNIT(dimension)
N(value)
NA()
NEGBINOM.DIST(number_f,number_s,probability_s,cumulative)
NEGBINOMDIST(number_f,number_s,probability_s)
NETWORKDAYS(start_date,end_date,holidays)
NETWORKDAYS.INTL(start_date,end_date,weekend,holidays)
NOMINAL(effect_rate,npery)
NORM.DIST(x,mean,standard_dev,cumulative)
NORMDIST(x,mean,standard_dev,cumulative)
NORMINV(probability,mean,standard_dev)
NORM.INV(probability,mean,standard_dev)
NORM.S.DIST(z,cumulative)
NORMSDIST(z)
NORM.S.INV(probability)
NORMSINV(probability)
NOT(logical)
NOW()
NPER(rate,pmt,pv,fv,type)
NPV(rate,value1,value2)
NUMBERVALUE(text,decimal_separator,group_separator)
OCT2BIN(number,places)
OCT2DEC(number)
OCT2HEX(number,places)
ODD(number)
ODDFPRICE(settlement,maturity,issue,first_coupon,rate,yld,redemption,frequency,basis)
ODDFYIELD(settlement,maturity,issue,first_coupon,rate,pr,redemption,frequency,basis)
ODDLPRICE(settlement,maturity,last_interest,rate,yld,redemption,frequency,basis)
ODDLYIELD(settlement,maturity,last_interest,rate,pr,redemption,frequency,basis)
OFFSET(reference,rows,cols,height,width)
OR(logical1,logical2)
PDURATION(rate,pv,fv)
PEARSON(array1,array2)
PERCENTILE.EXC(array,k)
PERCENTILE.INC(array,k)
PERCENTILE(array,k)
PERCENTRANK.EXC(array,x,significance)
PERCENTRANK.INC(array,x,significance)
PERCENTRANK(array,x,significance)
PERMUT(number,number_chosen)
PERMUTATIONA(number,number_chosen)
PHI(x)
PHONETIC(reference)
PI()
PMT(rate,nper,pv,fv,type)
POISSON.DIST(x,mean,cumulative)
POISSON(x,mean,cumulative)
POWER(number,power)
PPMT(rate,per,nper,pv,fv,type)
PRICE(settlement,maturity,rate,yld,redemption,frequency,basis)
PRICEDISC(settlement,maturity,discount,redemption,basis)
PRICEMAT(settlement,maturity,issue,rate,yld,basis)
PROB(x_range,prob_range,lower_limit,upper_limit)
PRODUCT(number1,number2)
PROPER(text)
PV(rate,nper,pmt,fv,type)
QUARTILE(array,quart)
QUARTILE.EXC(array,quart)
QUARTILE.INC(array,quart)
QUOTIENT(numerator,denominator)
RADIANS(angle)
RAND()
RANDARRAY(행,열,최소,최대,정수)
RANDBETWEEN(bottom,top)
RANK.AVG(number,ref,order)
RANK.EQ(number,ref,order)
RANK(number,ref,order)
RATE(nper,pmt,pv,fv,type,guess)
RECEIVED(settlement,maturity,investment,discount,basis)
REDUCE(initial_value,array,function)
REPLACE.REPLACEB()
REPT(text,number_times)
RIGHT.RIGHTB()
ROMAN(number,form)
ROUND(number,num_digits)
ROUNDDOWN(number,num_digits)
ROUNDUP(number,num_digits)
ROW(reference)
ROWS(array)
RRI(nper,pv,fv)
RSQ(knownys,knownxs)
RTD(progID,server,topic1,topic2)
SCAN(initial_value,array,function)
SEARCH.SEARCHB()
SEC(number)
SECH(number)
SECOND(serial_number)
SEQUENCE(rows,columns,start,step)
SERIESSUM(x,n,m,coefficients)
SHEET(value)
SHEETS(reference)
SIGN(number)
SIN(number)
SINH(number)
SKEW(number1,number2)
SKEW.P(number1,number2)
SLN(cost,salvage,life)
SLOPE(knownys,knownxs)
SMALL(array,k)
SORT(array,sort_index,sort_order,by_col)
SORTBY(array,by_array,sort_order)
SQRT(number)
SQRTPI(number)
STANDARDIZE(x,mean,standard_dev)
STOCKHISTORY(stock,start_date,end_date,interval,headers,properties1)
STDEV(number1,number2)
STDEV.P(number1,number2)
STDEV.S(number1,number2)
STDEVA(value1,value2)
STDEVP(number1,number2)
STDEVPA(value1,value2)
STEYX(knownys,knownxs)
SUBSTITUTE(text,old_text,new_text,instance_num)
SUBTOTAL(function_num,REF1)
SUM(number1,number2)
SUMIF(range,criteria,sum_range)
SUMIFS(sum_range,criteria_range,criteria)
SUMPRODUCT(array1,array2,array3)
SUMSQ(number1,number2)
SUMX2MY2(array_x,array_y)
SUMX2PY2(array_x,array_y)
SUMXMY2(array_x,array_y)
SWITCH(expression,value1,result1,default_or_value2,result2)
SYD(cost,salvage,life,per)
T(value)
TAN(number)
TANH(number)
TAKE(array,rows,columns)
TBILLEQ(settlement,maturity,discount)
TBILLPRICE(settlement,maturity,discount)
TBILLYIELD(settlement,maturity,pr)
T.DIST(x,deg_freedom,cumulative)
T.DIST.2T(x,deg_freedom)
T.DIST.RT(x,deg_freedom)
TDIST(x,deg_freedom,tails)
TEXT(value,format_text)
TEXTAFTER(text,delimiter,instance_num,match_mode,match_end,if_not_found)
TEXTBEFORE(text,delimiter,instance_num,match_mode,match_end,if_not_found)
TEXTJOIN(delimiter,ignore_empty,text1)
TEXTSPLIT(text,col_delimiter,row_delimiter,ignore_empty,match_mode,pad_with)
TIME(hour,minute,second)
TIMEVALUE(time_text)
T.INV(probability,deg_freedom)
T.INV.2T(probability,deg_freedom)
TINV(probability,deg_freedom)
TOCOL(array,ignore,scan_by_column)
TOROW(array,ignore,scan_by_column)
TODAY()
TRANSPOSE(array)
TREND(knownys,knownxs,newxs,const)
TRIM(text)
TRIMMEAN(array,percent)
TRUE()
TRUNC(number,num_digits)
T.TEST(array1,array2,tails,type)
TTEST(array1,array2,tails,type)
TYPE(value)
UNICHAR(number)
UNICODE(text)
UNIQUE(array,by_col,exactly_once)
UPPER(text)
VALUE(text)
VALUETOTEXT(value,format)
VAR(number1,number2)
VAR.P(number1,number2)
VAR.S(number1,number2)
VARA(value1,value2)
VARP(number1,number2)
VARPA(value1,value2)
VDB(cost,salvage,life,start_period,end_period,factor,no_switch)
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
VSTACK(array1,array2)
WEBSERVICE(url)
WEEKDAY(serial_number,return_type)
WEEKNUM(serial_number,return_type)
WEIBULL(x,alpha,beta,cumulative)
WEIBULL.DIST(x,alpha,beta,cumulative)
WORKDAY(start_date,days,holidays)
WORKDAY.INTL(start_date,days,weekend,holidays)
WRAPCOLS(vector,wrap_count,pad_with)
WRAPROWS(vector,wrap_count,pad_with)
XIRR(values,dates,guess)
XLOOKUP(lookup_value,lookup_array,return_array,if_not_found,match_mode,search_mode)
XMATCH(lookup_value,lookup_array,match_mode,search_mode)
XNPV(rate,values,dates)
XOR(logical1,logical2)
YEAR(serial_number)
YEARFRAC(start_date,end_date,basis)
YIELD(settlement,maturity,rate,pr,redemption,frequency,basis)
YIELDDISC(settlement,maturity,pr,redemption,basis)
YIELDMAT(settlement,maturity,issue,rate,pr,basis)
Z.TEST(array,x,sigma)
ZTEST(array,x,sigma)