EXCEL中按照排名百分比评分答:假设数据在A列,从A1开始,B1公式:=LOOKUP(RANK(A1,INDIRECT("A1:A"&COUNT(A:A)))/COUNT(A:A),{0,0.100001,0.325001,0.675001,0.900001},{5,4,3,2,1})下拉。
EXCEL表格自动生成文字后,百分比无法显示答:将需要以百分比表示的单元格在公式中以TEXT(C2,"0.00%")的格式替换。如 =CONCATENATE(A2,"当日",B2,"人",E2,"万元,同比",TEXT(C2,"0.00%"))