电子表格里如果a1=A那么b1=B,C,D;如果a1=Z那么b1=E,F,G答:B1输入 =IF(A1="A","B,C,D",IF(A1="Z","E,F,G",""))下拉
Excel 里,如果A1值为:a,b,c,d;则在B1显示为“B”;这个 IF函数,要怎 ...答:b1=IFERROR(VLOOKUP(A1,{"a","b";"b","b";"c","b";"d","b"},2,),"其他")
Excel 如果A1等于1,则B1等于“一”,A2等于2,则B2等于“二”答:第一步:点击开发工具-visual basic 第二步:插入模块,编制代码如下:Function dasz(a As Integer) As String Set d = CreateObject("scripting.dictionary")d.Add 1, "一"d.Add 2, "二"d.Add 3, "三"d.Add 4, "四"d.Add 5, "五"d.Add 6, "六"d.Add 7, "七"d.Add 8, "...