【字符争霸】第16期--检查算式

=IF(SUM(IFERROR(--MID(0&LEFT(A3,FIND("=",A3)-1),2*ROW($1:$15)-1,2),0))>--MID(A3,FIND("=",A3)+1,99),"差"&SUM(IFERROR(--MID(0&LEFT(A3,FIND("=",A3)-1),2*ROW($1:$15)-1,2),0))-(--MID(A3,FIND("=",A3)+1,99)),IF(SUM(IFERROR(--MID(0&LEFT(A3,FIND("=",A3)-1),2*ROW($1:$15)-1,2),0))<--MID(A3,FIND("=",A3)+1,99),"多"&--MID(A3,FIND("=",A3)+1,99)-SUM(IFERROR(--MID(0&LEFT(A3,FIND("=",A3)-1),2*ROW($1:$15)-1,2),0)),"正确"))，数组公式，笨人只能暴力解答了，长是长了点

baksy

B3公式（数组）；
=TEXT(MID(A3,FIND("=",A3)+1,9)-SUM(--MID(0&A3,ROW(OFFSET(A$1,,,FIND("=",A3)/2))*2-1,2)),"多0;差0;正确")

采姑娘的小蘑菇

1. =TEXT(MID(A3,FIND("=",A3)+1,3)+SUM(-MID("+"&A3,ROW(INDIRECT("1:"&FIND("=",A3)/2))*2-1,2)),"多#;差#;正确")

复制代码

ykqrs

1. =TEXT(SUM(--TEXT(MID("+"&LEFT(A3,FIND("=",A3)-1),ROW($$$$$$$$$$$$$$$$1:$$$$$$$$$$$$$$$$15)*2-1,2),"0;-0;0;!0"))+LOOKUP(9^9,-RIGHT(A3,COLUMN(1:1))),"差0;多0;正确")

复制代码

又是10个BB
哦，可以用高版本函数，可惜只会iferror,根据数据特点，求和最多三位数，短一点

1. =TEXT(SUM(IFERROR(--MID("+"&LEFT(A3,LEN(A3)-1)&"a",ROW($$$$$$$$$$$$$$$$1:$$$$$$$$$$$$$$$$15)*2-1,2),))+LOOKUP(,-RIGHT(A3,COLUMN(1:1))),"差0;多0;正确")

复制代码

估计我再想不出短一点的了
顺⑦.zì繎。  这头像好熟悉。。。。。  发表于 2015-1-8 12:03
我在EH论坛有位好友和你一摸一样
真是奇怪，怎么贴上的公式变了
=TEXT(SUM(IFERROR(--MID("+"&LEFT(A3,LEN(A3)-1)&"a",ROW($1:$15)*2-1,2),))+LOOKUP(,-RIGHT(A3,COLUMN(1:1))),"差0;多0;正确")
再这样粘贴试试

daniel32

=TEXT(LEFT(A3)+SUM(SUBSTITUTE(MID(A3,ROW(INDIRECT("1:"&FIND("=",A3)/2-1))*2,2),"+",)*1)-MID(A3,FIND("=",A3)+1,3),"差0;多0;正确")

小福贵

=TEXT(SUM(-MID(0&A3,ROW(INDIRECT("1:"&FIND("=",A3)/2))*2-1,2))+MID(A3,FIND("=",A3)+1,9),"多#;差#;正确")

=TEXT(-LOOKUP(,-RIGHT(A3,ROW($1:$9)))-SUM(IFERROR(--MID(MID("+"&A3,1,FIND("=",A3)+1),ROW($1:$15)*2-1,2),0)),"多0;差0;正确;")，数组公式。

路边的记忆

冒个泡泡

1. =TEXT(SUM(--TEXT(SUBSTITUTE(MID("+"&SUBSTITUTE(A3,"=",REPT(" ",99)),ROW($1:14)*2-1,2)," ",),"0;-0;0;!0"))+LOOKUP(,-RIGHT(A3,{1,2,3})),"差0;多0;正确")

复制代码

gdpgdp317

一个超长的
=SUBSTITUTE(IF(RIGHT(A3,LEN(A3)-FIND("=",A3))-SUM(--SUBSTITUTE(MID("+"&A3,ROW(INDIRECT("1:"&FIND("=",A3)/2))*2-1,2),"+",)),"多"&RIGHT(A3,LEN(A3)-FIND("=",A3))-SUM(--SUBSTITUTE(MID("+"&A3,ROW(INDIRECT("1:"&FIND("=",A3)/2))*2-1,2),"+",)),"正确"),"多-","差")

再来一个短点的
=TEXT(RIGHT(A3,LEN(A3)-FIND("=",A3))-SUM(--SUBSTITUTE(MID("+"&A3,ROW(INDIRECT("1:"&FIND("=",A3)/2))*2-1,2),"+",)),"多0;差0;正确")

wlc520113000

1. =TEXT(SUM(-MID(0&A3,ROW(INDIRECT("1:"&FIND("=",A3)/2))*2-1,2))+MID(A3,FIND("=",A3)+1,4),"多0;差0;正确")

复制代码