EXCEL 函数问题:MID($C$162,FIND("F",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))+1MID($C$162,FIND("F",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))+1,FIND("/",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))-FIND("F",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/03 18:27:56
EXCEL 函数问题:MID($C$162,FIND(

EXCEL 函数问题:MID($C$162,FIND("F",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))+1MID($C$162,FIND("F",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))+1,FIND("/",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))-FIND("F",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1
EXCEL 函数问题:MID($C$162,FIND("F",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))+1
MID($C$162,FIND("F",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))+1,FIND("/",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))-FIND("F",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))-1)+MID(C162,FIND("Y",C162,FIND("=",C162,FIND(A5,C162,1)))+1,FIND("//",C162,FIND("=",C162,FIND(A5,C162,1)))-FIND("Y",C162,FIND("=",C162,FIND(A5,C162,1)))-1)
有没有高手知道这个是什么意思,我猜应该是找F和Y的总数,不知道对不对,我要再想加上W应该怎么输

EXCEL 函数问题:MID($C$162,FIND("F",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))+1MID($C$162,FIND("F",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))+1,FIND("/",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))-FIND("F",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1
MID(单元格,X,Y)表示在单元格中,取从第X个字符开始的一共Y个字符
所以这个函数是要摘取C162单元格中部分内容
后面的就太长了,要一个一个解释吗?