EXCEL表格中如何实现随机生成0-9的数字与+-*/<>的符号组成,急求!详细点

如题所述

举报该问题

推荐答案 2011-05-11

假如你要在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下拉即可

温馨提示：答案为网友推荐，仅供参考

当前网址：http://77.wendadaohang.com/zd/Y3IYvNppq.html

其他回答

第1个回答 2011-05-11

=INT(RAND()*10) & “需要的计算符号”

第2个回答 2011-05-11

=ROUND(RAND()*9,0)&"+-*/<>"

第3个回答 2011-05-17

见下图

图中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能得结果

相似回答

大家正在搜