excel有两列,第一列有数字我想第二列数字大于10的显示A,大于5小于10...答:=IF(A1>10,"A",IF(A1>5,"B","C"))或 =IF(A1<5,"C",IF(A1<10,"B","A"))或 =IF(A1="","",LOOKUP(A1,{-9E+307,5,10}+10^-8,{"C","B","A"}))下拉填充
怎样在Excel表中让第二列的内容和第一列对应答:EXCEL表中如何让第二列的内容和第一列的相同内容对应的方法如下:1、公式法:假设数据从A2,B2开始 (1)在A列后插入辅助列B列,在b2输入=IF(ISERROR(VLOOKUP(A2,C:E,3,0)),"",0),下拉至结尾,(2)在c列后插入辅助列D列,在D2输入=IF(ISERROR(VLOOKUP(C2,A:B,2,0)),"",1),...