excel - 如何生成随机字符串RANDBETWEEN？

Question

我正在使用这个公式来生成一个随机代码：

=RANDBETWEEN(0,9)&CHAR(RANDBETWEEN(65,9))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(33,47))&RANDBETWEEN(0,9)&CHAR(RANDBETWEEN(65,9))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(33,47))

而不是看起来像这样的东西：6Ib&4Rj/，我得到

姓名？错误

任何人都可以看到我错过了什么？

标签： excelrandom

Answer 1

RANDBETWEEN要求第一个参数小于第二个参数。

RANDBETWEEN(65,9)替换with的所有实例，RANDBETWEEN(9,65)这应该可以解决您的问题。