搜索
函数类型格式taday()now()date(year,month,day)datevalue(date_text)year(serial_number)month(serial_number)day(serial_number)time(hour,minute,second)timevalue(time_text)hour(serial_number)minute(serial_number)second(serial_number)weekday(serial_number,return_type)weeknum(serial_num,return_type)edate(start_date,months)eomonth(start_date,months)workday(start_date,days,holidays)networkdays(start_date,end_date,holidays)days360(start_date,end_date,method)yearfrac(start_date,end_date,basis)if(logical_test,value_if_true,value_if_false)and(logical1,logical2,…)or(logical1,logical2,…)not(logical)true()false()iferror(value,value_if_error)cell(info_type,reference)error.type(error_val)info(type_text)n(value)na()type(value)isblank(value)iserr(value)iserror(value)iseven(number)islogical(value)isna(value)isnontext(value)isnumber(value)isodd(number)isref(value)istext(value)abs(number)sum(number1,number2,…)日期、时间函数逻辑函数信息函数数学和三角函数sumif(range,criteria,sum_range)product(number1,number2,…)sumproduct(array1,array2,…)sumpsq(nmuber1,nmuber2,…)sumx2py2(array_x,array_y)sumx2my2(array_x,array_y)sumxmy2(array_x,array_y)subtotal(function_num,ref1,ref2,…)quotient(numerator,denominator)mod(number,divisor)sign(number)gcd(number1,number2,…)lcm(number1,number2,…)seriessum(x,n,m,coefficients)int(number)trunc(number,num_digits)round(number,num_digits)roundup(number,num_digits)rounddown(number,num_digits)ceiling(number,significance)floor(number,significance)mround(number,multiple)even(number)odd(number)radians(angle)degrees(angle)sin(number)cos(number)tan(number)asin(number)acos(number)atan(number)atan2(x_num,y_num)sinh(number)cosh(number)tanh(number)asinh(number)acosh(number)atanh(number)power(number,power)exp(number)log(number,base)ln(number)log10(number)rand()randbetween(bottom,top)pi()数学和三角函数sqrt(number)sqrtpi(number)mdeterm(array)minverse(number)mmult(array1,array2)fact(number)factdouble(number)combin(number,number_chosen)multinomial(number1,number2,…)roman(number,form)address(row_num,column_num,abs_num,a1,sheet_text)column(reference)row(reference)areas(reference)columns(array)rows(array)choose(index_num,value1,value2,…)match(lookup_value,lookup_array,match_type)lookup(lookup_value,lookup_vector,result_vector)hlookup(lookup_value,table_array,row_index_num,range_lookup)vlookup(lookup_value,table_array,col_index_num,range_lookup)index(array,row_num,column_num)index(reference,row_num,column_num,area_num)indirect(ref_text,a1)offset(reference,rows,cols,height,width)transpose(array)hyperlink(link_location,friendly_name)rtd(ProgID,server,topic1,topic2,…)find(find_text,within_text,start_num)findb(find_text,within_text,start_num)search(find_text,within_text,start_num)searchb(find_text,within_text,start_num)lower(text)upper(text)proper(text)char(number)code(text)text(value,format_text)value(text)bahttext(number)dollar(number,decimals)rmb(number,decimals)phonetic(reference)clean(text)concatenate(text1,text2,…)trim(text)asc(text)查找和引用函数数学和三角函数文本函数widechar(text)substitute(text,old_text,new_text,instance_num)len(text)lenb(text)exact(text1,text2)fixed(number,decimals,no_commas)replace(old_text,start_num,num_chars,new_text)replaceb(old_text,start_num,num_bytes,new_text)left(text,num_chars)leftb(text,num_bytes)mid(text,start_num,num_chars)midb(text,start_num,num_bytes)rept(text,number_times)t(value)right(text,num_chars)rightb(text,num_bytes)daverage(database,field,criteria)dcount(database,field,criteria)dcounta(database,field,criteria)dget(database,field,criteria)dmax(database,field,criteria)dmin(database,field,criteria)dproduct(database,field,criteria)dstdev(database,field,criteria)dstdevp(database,field,criteria)dsum(database,field,criteria)dvar(database,field,criteria)dvarp(database,field,criteria)call(register_id,argument1,…)call(module_text,procedure,type_text,argument1,…)call(file_text,resource,type_text,argument1,…)euroconvert(number,source,target,full_precision,triangulation_precision)getpivotdata(data_field,pivot_table,field1,item1,field2,item2,…)register.id(module_text,procedure,type_text)sql.request(connection_string,output_ref,driver_prompt,query_text,col_names_logical)count(value1,value2,…)counta(value1,value2,…)countblank(range)countif(range,criteria)frequency(data_array,bins_array)average(number1,number2,…)averagea(value1,value2,…)trimmean(array,percent)geomean(number1,number2,…)median(number1,number2,…)mode(number1,number2,…)harmean(number1,number2,…)max(number1,number2,…)maxa(value1,value2,…)统计函数文本函数数据库函数外部函数min(value1,value2,…)mina(value1,value2,…)quartile(array,quart)percentile(array,k)percentrank(array,x,significance)var(number1,number2,…)vara(value1,value2,…)varp(number1,number2,…)varpa(value1,value2,…)stdev(number1,number2,…)stdeva(value1,value2,…)stdevp(number1,number2,…)stdevpa(value1,value2,…)avedev(number1,number2,…)devsq(number1,number2,…)skew(number1,number2,…)kurt(number1,number2,…)chidist(x,degrees_freedom)chiinv(probability,degrees_freedom)chitest(actual_range,expected_range)fdist(x,degrees_freedom1,degrees_freedom2)finv(probability,deg