excel自动出题加减混合（连加连减）？

Question

请问这个公式是不是有问题？想做一个连加连减混合口算公式，可是总是会出现像42-70这样“小数-大数”的现象，请问要如何改？谢谢公式是：=RANDBETWEEN(1,100)&LOOKUP(RANDBETWEEN(1,4),{1,"+";2,"-"})&RANDBETWEEN(1,100)&LOOKUP(RANDBETWEEN(1,4),{1,"+";2,"-"})&RANDBETWEEN(1,100)&"="

Answer 1

建议你把公式分开写，然后在最后一个单元格合并：

=A1&IF(B1>A1,"+",LOOKUP(RANDBETWEEN(0,2),{0,"+";1,"-"}))&B1&IF(B1<A1,"+",LOOKUP(RANDBETWEEN(0,2),{0,"+";1,"-"}))&C1&"="

Answer 2

外面嵌套个
=ABS
绝对值
=ABS(RANDBETWEEN(1,100)&LOOKUP(RANDBETWEEN(1,4),{1,"+";2,"-"})&RANDBETWEEN(1,100)&LOOKUP(RANDBETWEEN(1,4),{1,"+";2,"-"})&RANDBETWEEN(1,100)&"=")
嵌套你原来的公式

Answer 3

加与减用一个随机数分开来做，加随便你都可以，减的时候需要把减数随机数后面的减半、被减数前面的随机数增大
=IF(RANDBETWEEN(0,1),加部分,减部分)

Answer 4

加与减用一个随机数分开来做，加随便你都可以，减的时候需要把减数随机数后面的减半、被减数前面的随机数增大
=IF(RANDBETWEEN(0,1),加部分,减部分)

Answer 5

加与减用一个随机数分开来做，加随便你都可以，减的时候需要把减数随机数后面的减半、被减数前面的随机数增大
=IF(RANDBETWEEN(0,1),加部分,减部分)本回答被提问者采纳