D2=TEXT(SUM(TEXT({1,-1}%,SUBSTITUTE(C2,"-",";"))*{1,-1}),"!"&LEFT(B2,FIND("-",B2)-1)&";!"&MID(B2,FIND("-",B2)+1,9)&";平手")
另解=TEXT(SUM(MID(SUBSTITUTE(C2,"-",REPT(" ",9)),{1,9},9)*{1,-1}),"!"&LEFT(B2,FIND("-",B2)-1)&";!"&MID(B2,FIND("-",B2)+1,9)&";平手")
留言
張貼留言