如何在Excel中自动生成带公式的区间标签?答:假设你的数据在A列,从A2开始,你可以在B2单元格输入以下公式: =IF(A2<=10,"0-10",IF(A2<=20,"10-20",IF(A2<=30,"20-30",IF(A2<=40,"30-40",IF(A2<=50,"40-50",IF(A2<=60,"50-60",IF(A2<=70,"60-70",IF(A2<=80,"70-80",IF(A2<=90,"80-90","90-100"))...
求excel中什么公式能自动生成指定数字±一定量的,多个逗号隔开的随机...答:公式为:=TEXTJOIN(",",,RANDBETWEEN(A1*10-20,A1*10+20)/10,RANDBETWEEN(A1*10-20,A1*10+20)/10,RANDBETWEEN(A1*10-20,A1*10+20)/10)如图所示:每多一个数,加一个RANDBETWEEN(A1*10-20,A1*10+20)/10即可。