å¯ä»¥ç»å462ç»ä¸éå¤çï¼ç®åå¾ä¸è½å¨ç®åäºï¼1å°11个æ°åï¼5个ç»åæä¸ç»ï¼ä¸éå¤ï¼å¦æ没çéæ¯11é5
ä¸é¢å°±ä»ç»ä¸å®ç°æ¹æ³ï¼ä¸ºäºè½æ´å¥½å¾åå¼ï¼è®©æ°åèªå¨åæ¢ï¼æç¨äºå ¶å®ç¬¦å·è¿æ¥å符ï¼
åå¦B3=1/2Ã3-4+5 (ä¹å°±æ¯ä½ 说å¾5个ä¸ç»å)
B4
å
¬å¼åä¸æ=IF(B3="","",IF(--RIGHT(B3,2)<11,LEFT(B3,5)&"-"&
MID(B3,FIND("-",B3)+1,FIND("+",B3)-FIND("-",B3)-1)+1&"+"&MID(B3,FIND("-",B3)+1,FIND("+",B3)-FIND("-",B3)-1)+2,IF(AND(--LEFT(B3,1)=7,--MID(B3,3,1)=8,--MID(B3,5,1)=9,--MID(B3,7,2)=10,--RIGHT(B3,2)=11),"",IF(AND(--LEFT(B3,1)<7,--MID(B3,3,1)=8,--MID(B3,5,1)=9,--MID(B3,7,2)=10,--RIGHT(B3,2)=11),LEFT(B3,1)+1&"/"&LEFT(B3,1)+2&"Ã"&LEFT(B3,1)+3&"-"&LEFT(B3,1)+4&"+"&LEFT(B3,1)+5,IF(AND(--MID(B3,3,1)<8,--MID(B3,5,1)=9,--MID(B3,7,2)=10,--RIGHT(B3,2)=11),LEFT(B3,1)&"/"&MID(B3,FIND("/",B3)+1,FIND("Ã",B3)-FIND("/",B3)-1)+1&"Ã"&MID(B3,FIND("/",B3)+1,FIND("Ã",B3)-FIND("/",B3)-1)+2&"-"&MID(B3,FIND("/",B3)+1,FIND("Ã",B3)-FIND("/",B3)-1)+3&"+"&MID(B3,FIND("/",B3)+1,FIND("Ã",B3)-FIND("/",B3)-1)+4,IF(AND(--MID(B3,FIND("Ã",B3)+1,FIND("-",B3)-FIND("Ã",B3)-1)<9,--MID(B3,FIND("-",B3)+1,FIND("+",B3)-FIND("-",B3)-1)=10,--RIGHT(B3,2)=11),LEFT(B3,4)&MID(B3,FIND("Ã",B3)+1,FIND("-",B3)-FIND("Ã",B3)-1)+1&"-"&MID(B3,FIND("Ã",B3)+1,FIND("-",B3)-FIND("Ã",B3)-1)+2&"+"&MID(B3,FIND("Ã",B3)+1,FIND("-",B3)-FIND("Ã",B3)-1)+3,))))))
C3å ¬å¼åå³æå¨åä¸æ=IF(B3="","",IF(--RIGHT(B3,2)=11,"",LEFT(B3,8)&--RIGHT(B3,2)+1))