excel自动出题加减混合(连加连减)?答:回答:建议你把公式分开写,然后在最后一个单元格合并: =A1&IF(B1>A1,"+",LOOKUP(RANDBETWEEN(0,2),{0,"+";1,"-"}))&B1&IF(B1<A1,"+",LOOKUP(RANDBETWEEN(0,2),{0,"+";1,"-"}))&C1&"="
用Excel做100以内乘法连加连减 自动出题答:=RANDBETWEEN(1,100)&CHOOSE(RANDBETWEEN(1,3),"+","-","×")&RANDBETWEEN(1,100)&CHOOSE(RANDBETWEEN(1,3),"+","-","×")&RANDBETWEEN(1,100)&"="