本帖最后由 tgydslr 于 2015-1-7 09:28 编辑
- =TEXT(SUM(IFERROR(--MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE("+"&A2,"+","+00"),"-","-00"),"=","-"),COLUMN(A:P)*4-3,4),)),"差0;多0;正确")
复制代码 很羞108字符,争取再减字符- =TEXT(RIGHT(A3,LEN(A3)-FIND("=",A3))-SUM(--MID("+"&A3,ROW(INDIRECT("1:"&FIND("=",A3)/2))*2-1,2)),"多0;差0;正确")
复制代码 减1个再说- =TEXT(RIGHT(A3,LEN(A3)-FIND("=",A3))+SUM(-MID("+"&A3,ROW(INDIRECT("1:"&FIND("=",A3)/2))*2-1,2)),"多0;差0;正确")
复制代码 再减几个,101字符了,争取走进100- =TEXT(MID(A3,FIND("=",A3)+1,3)+SUM(-MID("+"&A3,ROW(INDIRECT("1:"&FIND("=",A3)/2))*2-1,2)),"多0;差0;正确")
复制代码 |