要一个100以内乘除法自动出题的Excel表格,比如56÷8×5=,连乘连除也可以,刷新就有新的题目就行。

2024-11-18 22:41:13
推荐回答(2个)
回答(1):

公式如下:

=RANDBETWEEN(1,100)&LOOKUP(RANDBETWEEN(1,4),{1,"+";2,"-";3,"*";4,"/"})&RANDBETWEEN(1,100)&LOOKUP(RANDBETWEEN(1,4),{1,"+";2,"-";3,"*";4,"/"})&RANDBETWEEN(1,100)&"="

结果见图:

回答(2):

得数是100以内还是加减乘除数是100以内?