建议你把公式分开写，然后在最后一个单元格合并：
=A1&IF(B1>A1,"+",LOOKUP(RANDBETWEEN(0,2),{0,"+";1,"-"}))&B1&IF(B1
外面嵌套个
=ABS
绝对值
=ABS(RANDBETWEEN(1,100)&LOOKUP(RANDBETWEEN(1,4),{1,"+";2,"-"})&RANDBETWEEN(1,100)&LOOKUP(RANDBETWEEN(1,4),{1,"+";2,"-"})&RANDBETWEEN(1,100)&"=")
嵌套你原来的公式
加与减用一个随机数分开来做，加随便你都可以，减的时候需要把减数随机数后面的减半、被减数前面的随机数增大
=IF(RANDBETWEEN(0,1),加部分,减部分)
加与减用一个随机数分开来做，加随便你都可以，减的时候需要把减数随机数后面的减半、被减数前面的随机数增大
=IF(RANDBETWEEN(0,1),加部分,减部分)
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024