Excel自动生成100以内加减混合运算带括号?
发布网友
发布时间:2022-09-20 16:08
我来回答
共1个回答
热心网友
时间:2023-07-01 09:13
复制以下公式,粘贴到任意单元格,右拉下拉即可
=CHOOSE(RANDBETWEEN(1,4),RANDBETWEEN(10,40)&"+("&RANDBETWEEN(10,30)&"+"&RANDBETWEEN(10,30)&")",RANDBETWEEN(10,30)&"+("&RANDBETWEEN(50,99)&"-"&RANDBETWEEN(30,50)&")",RANDBETWEEN(60,99)&"-("&RANDBETWEEN(10,30)&"+"&RANDBETWEEN(10,30)&")",RANDBETWEEN(60,99)&"-("&RANDBETWEEN(60,99)&"-"&RANDBETWEEN(40,60)&")")&"="