Excel函数

发布时间：2020-03-02 06:17:05 来源：范文大全收藏本文下载本文手机版

合并

合并“姓”和“名” =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