[已解决]单元格个位数加十位数的得数

pgc999888

风林火山 发表于 2014-3-6 23:51

当十位数为0时无法计算
如01……09

pgc999888

风林火山的答案主要是当出现01……09的时候无法计算，风林火山大哥在努力一下帮帮忙啊万分感谢您

xdragon

1. =MID("红绿红蓝绿红蓝绿蓝绿绿红绿红红蓝红蓝蓝绿红蓝蓝绿红绿",2*(INT(I2/10)+MOD(I2,10))-1,2)

复制代码

tgydslr

1. =MID("红绿红蓝绿红蓝绿蓝绿绿红绿红红蓝红蓝蓝绿红蓝蓝绿红绿",SUMPRODUCT(--MID(A1,{1,2},1))*2-1,2)

复制代码

1. =INDEX({"红绿","红蓝","绿红","蓝绿","蓝绿","绿红","绿红","红蓝","红蓝","蓝绿","红蓝","蓝绿","红绿"},SUMPRODUCT(--MID(A1,{1,2},1)))

复制代码