Excel自动生成100以内加减混合带括号运算,结果不大于100、不小于0.如图所示。求大神解答
å¤å¶ä»¥ä¸å
¬å¼ï¼ç²è´´å°ä»»æåå
æ ¼ï¼å³æä¸æå³å¯
=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)&")")&"="
=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)&")")&"="
温馨提示:答案为网友推荐,仅供参考