excel中1f函数的运用答:=if((a1<2)*(a1>=1),74%,(if((a1<3)*(a1>=2),80%,(if((a1<4)*(a1>=3),90%,if((a1<5)*(a1>=4),96%,if((a1<5)*(a1>=5),98%,0)))
excel如何快速输入1A,1B,1C,1D,1E,1F,1G...等等类似的,前面为数字,后 ...答:按你的意思,在任一单元格输入 =INT(ROW(A26)/26) &CHAR(IF(MOD(ROW(A27),26),MOD(ROW(A27),26),26)+64)然后下拉填充,就实现 1A,1B,1C,1D,1E,1F,1G...1Z 2A,2B,2C,2D,2E,2F,2G...2Z ...