数据的拆分与合并
39790
1910101 22.2410201 TRUE10901 #DIV/0!
公式
公式说明(结果)
=COUNTA(A2:A8)计算上列数据中
非空单元格的个
数 (6)=COUNT(A1:A8)
=COUNTA(A5:A8)计算上列数据的最后四行中非空单元格的个数(4)
count()
=LEFT(SUBSTITUTE(E3,370682*********=SUBSTITUTE(G3,MID(G3,7,2),"19"&M =LEFT(SUBSTITUTE(E4,
=LEFT(SUBSTITUTE(E5,
=COUNT( ,"1",1)
=TRIM(" s t ")=RIGHT("asd",5)=TEXT(1,"000.00")
=FIND("c","ccccdabcd
=ROUND(355.26,-2)
=REPT("123",3)
相关主题