excel表格,如果A列数字是1则B列显示是,A列是2则B列显示否,怎么弄?答:B1填入以下公式:=if(A1=1,"是",if(A1=2,"否",""))即可 或者 =Choose(A1,"是","否")或者 =vlookup(A1,{1,"是";2,"否"},2,)
电子表格中如何编辑下列语句(如果是A则数值是1 如果是B数值是5)答:假设要判断的数据放在A1,B1公式:=IF(A1="A",1,IF(A1="B",5,""))补充:超过7个可用:=IF(A1="A",1,IF(A1="B",5,"")) &IF(A1="G",30,IF(A1="H",35,""))用LOOKUP更简单 =LOOKUP(A1,{A,B,C,D,E,F,G,H},{1,5,10,15,20,25,30,35})...