excel中,A1中数据大于1小于10,B1出现“ok”,反之出现“no”,有几种公 ...答:在B1中键入公式:IF(A1<=1,“No”,IF(A1>=10,"No","Ok")) 或者 IF(A1>1,IF(A1<10,"Ok","No"),"No") ………
EXCEL 若A1=1,B1=8,9,0,1,2,3,4中任意一个数字,则C1显示“正确”,该如...答:示意图如下:在C1中输入公式:=IF(B1="","",IF(ISNUMBER(MATCH(B1,E9:E15,0)),"正确","")) ,下拉,在D1中输入数字"0"在D2中输入数字"1"在D3中输入数字"2"选取单元格区域D1:D3,把光标置于该区域右下角,当光标处变成实心的十字时,下拉.在E1中输入公式:=OFFSET(D$1,MOD(ROW(A1)-1...
EXCEL中单元格数值比如是A1,如何列函数公式?答:=IFS(OR(A1<6,AND(A1>6,A1<7)),140,OR(A1={6,7}),120,OR(AND(A1>7,A1<8),AND(A1>8,A1<9)),154,OR(A1={8,9}),132,A1>9,0)*A1