EXCEL表格中如何实现随机生成0-9的数字与+-*/<>的符号组成,急求!详细点
展开全部
假如你要在A1随机生成0-9,+-*/<>这16个字符中的任意一个,则A1公式如下:
=LOOKUP(RAND()*16,{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15},{0,1,2,3,4,5,6,7,8,9,"+","-","*","/","<",">"})
点击A1下拉即可
=LOOKUP(RAND()*16,{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15},{0,1,2,3,4,5,6,7,8,9,"+","-","*","/","<",">"})
点击A1下拉即可
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
=INT(RAND()*10) & “需要的计算符号”
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
=ROUND(RAND()*9,0)&"+-*/<>"
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
见下图
图中A1到U1中的公式皆为=CHOOSE(INT(RAND()*16+1),0,1,2,3,4,5,6,7,8,9,"+","-","*","/","<",">")
A3的公式为=A1&B1&C1&D1&E1&F1&G1&H1&I1&J1&K1&L1&M1&N1&O1&P1&Q1&R1&S1&T1&U1
按F9即可随机变动A3的内容，松开F9能得结果
图中A1到U1中的公式皆为=CHOOSE(INT(RAND()*16+1),0,1,2,3,4,5,6,7,8,9,"+","-","*","/","<",">")
A3的公式为=A1&B1&C1&D1&E1&F1&G1&H1&I1&J1&K1&L1&M1&N1&O1&P1&Q1&R1&S1&T1&U1
按F9即可随机变动A3的内容，松开F9能得结果
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
更多回答（2）
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
