例如:A1=“AB100”,B1=20
C1输入公式:
=B1/MID(A1,FIND("|",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"1","|"),"2","|"),"3","|"),"4","|"),"5","|"),"6","|"),"7","|"),"8","|"),"9","|"),"0","|")),LEN(A1))
计算结果:
AB100 20 20.00%
怎么只提取单元格里的数字参加计算?
难点在于判断数字从哪一位开始,例如由"AB100”构造"AB|||",用FIND函数可以找到"AB|||"中"|"从第3位开始,即"AB100”的数字从第3位开始。再用MID函数从"AB100”中提取出数字100参加计算。
温馨提示:答案为网友推荐,仅供参考