b2=MAX(IFERROR(--RIGHT(LEFT(A2,MAX(IFERROR(FIND({"+","乘","X"},A2),0))-1),ROW($1:$100)),0))/100
昨天,这个函数,如果有小数的话,会出错,请问应该怎么改
è°ç¥éä½ æ¨å¤©æ¯ä»éº¼é®é¢?å¦ä½ç»çæ¡?çççå§!å¦æªå¾ï¼
B2=LOOKUP(9^9,--RIGHT(LEFT(A2,MAX(IFERROR(FIND({"+","ä¹","X"},A2),0))-1),ROW($1:$100)))/100
C2=-LOOKUP(,-RIGHT(LEFT(A2,MAX(IFERROR(FIND({"+","ä¹","X"},A2),))-1),ROW($1:$99)))%
D2=LOOKUP(9^9,--MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&2/19)),ROW($1:$99)))%
以ä¸æ¯å第ä¸ç»æ°å(æ°ååé¢è¿ææå)
E2=-LOOKUP(,-LEFT(A2,ROW($1:$15)))%----å¦ææ°åå¨æåé¢ï¼åæ左边çæ°å