Excel函数由刀豆文库小编整理，希望给你工作、学习、生活带来方便，猜你可能喜欢“excel函数”。
合并
合并“姓”和“名” =D5&“ ”&E5 合并日期与文本
=“时间：”&TEXT(F5, “d-mmm-yy”)
基于单个条件求和SUMIF(range,criteria,sum_range)
=SUMIF(B3:B8,“>20”,D3:D8)
TEXT(value,format_text)TEXT(2.715, “￥0.00”)等于 “￥2.72” TEXT(“4/15/91”, “mmmm dd, yyyy”)等于 “April 15, 1991”
IF(logical_test,value_if_true,value_if_false)。
例：=IF(SUM(C5:F5),SUM(C5:F5),“”)、=IF(B11>60,“合格”,“不合格”)
文本函数 大小写
Lower（pLease ComE Here!）= please come here!upper（pLease ComE Here!）= PLEASE COME HERE!proper（pLease ComE Here!）= Please Come Here!
取出字符串中的部分字符 LEFT(text,num_chars)MID(text,start_num,num_chars)RIGHT(text,num_chars)Eg.LEFT(“This is an apple”,4)=This
RIGHT(“This is an apple”,5)=apple
MID(“This is an apple”,6,2)=is
去除字符串的空白
TRIM(” My name is Mary
")=My name is Mary
