EXCEL如何快速分段?答:B1单元格输入公式=IF(LEN(A1)=4,A1,IF(LEN(A1)=6,TEXT(A1,"0!.00"),IF(LEN(A1)=8,TEXT(A1,"0!.00!.00"),IF(LEN(A1)=10,TEXT(A1,"0!.00!.00!.00"),IF(LEN(A1)=12,TEXT(A1,"0!.00!.00!.00!.00"),IF(LEN(A1)=14,TEXT(A1,"0!.00!.00!.00!.00!.00")))...
Excel分段统计分数答:E2(1000米成绩)输入 =LOOKUP(D2,{0,3.51,3.59,4.1,4.16,4.3,4.45,4.55,5.041,5.05},{11,10,9,8,7,6,5,4,3,2})G2(实心球成绩)输入 =LOOKUP(F2,{0,4.3,5.4,7,8.3,9.6},{2,3,4,5,6,7})I2(跳远成绩)输入 =LOOKUP(H2,{0,1.84,1.94,2.13,2.27...