[开_151]随机小学生加法计算式

小灰不灰

C2=TEXT(SUM(RANDBETWEEN(10,FREQUENCY(ROW($1:$99),RANDBETWEEN(10,89)))*{100;1}),"00+00")&"="

太阳之子

1. =TEXT(LARGE((RANDBETWEEN(20,F3:AS3+99)-ROW($10:91))/1%+ROW($10:91),RAND()*999+1),"0+00")
   
2. =TEXT(SUM(INT(ABS({1,0}-RAND())*RAND()*80+10)*{100,1}),"0+00")

复制代码

七夕、

占个坑

1. =TEXT(SUM(RANDBETWEEN(10,ABS({0,99}-RANDBETWEEN(10,89)))*{100,1}),"0+00=")

复制代码

梦幻小丑

1. =TEXT(SUM(INT(RAND()*80*ABS({1,0}-RAND())+10)*{100,1}),"0+00=")

复制代码

Leon01314

=TEXT(SUM(INT(MOD(MAX(RAND(),0.25)*{80,-80},99)*MAX(RAND(),0.5))*{100,1}),"0+00")

红旗雪

1. =TEXTJOIN("+",,RANDBETWEEN(10,99*{1,0}-RANDBETWEEN(10,89)*{1,-1}))&"="

复制代码

opqazxc

1. =TEXT(SUM(FREQUENCY(ROW($2:$80),RANDBETWEEN({0,0},80))*{1;100;0})+1010,"0+00=")

复制代码

1. =TEXT(SUM(INT(MOD(RAND()*{80,-80},80)*RAND()+10)*{1,100}),"0+00=")

复制代码

16函数。。

1. =TEXTJOIN("+",,INT(MOD(RAND()*{80,-80},80)*RAND()+10))&"="

复制代码

int里的参数改为

1. ABS(RAND()-{1,0})*RAND()*80+10

复制代码

  ，可以减多三个字符``

1. =TEXTJOIN("+",,INT(ABS(RAND()-{1,0})*RAND()*80+10))&"="

复制代码

``

parobird

=MOD(SECOND(NOW())*ROW(),80)+10&"+"&RANDBETWEEN(0,79-MOD(SECOND(NOW())*ROW(),80)+10）&"="

=MOD(ROW(),80)+10&"+"&RANDBETWEEN(0,79-MOD(ROW(),80))+10&"="

补充内容 (2017-6-5 08:16):
=MOD(SECOND(NOW())*ROW(),80)+10&"+"&RANDBETWEEN(0,79-MOD(SECOND(NOW())*ROW(),80))+10&"="
第一个括号错了

kuangben8

难度不大吗？为什么我会写出一个这么长的！！！
158字符，等待精简。。。。

1. =TEXT(LOOKUP(RANDBETWEEN(1010,9999),--TEXT(MMULT(--IF(RANDBETWEEN(20,99)=ROW(10:99)+COLUMN(J:CU),ROW(10:99)*100+COLUMN(J:CU)),ROW(1:90)^0),"[>]0;")),"00+00=")

复制代码

大幅度精简：102字符，距离目标很近了啊！

1. =TEXT(SMALL(IF(ROW(10:99)+COLUMN(J:CU)<100,ROW(10:99)*100+COLUMN(J:CU)),RANDBETWEEN(1,3240)),"00+00=")

复制代码

98字符了。。。。。。。

1. =TEXT(LARGE((ROW(1:80)+COLUMN(A:CB)<82)*(ROW(10:89)/1%+COLUMN(J:CK)),RANDBETWEEN(1,3240)),"0+00=")

复制代码

努力！努力！！

说不好

1. =TEXT(SUM(RANDBETWEEN(10,ABS(RANDBETWEEN(10,89)-{0;99}))*{100;1}),"0+00=")

复制代码