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

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

2025-01-07 00:44:22

推荐回答（4个）

回答1：

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

回答2：

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

回答3：

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

回答4：

见下图

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