標題: [發問] IF多重判斷，請幫忙，謝謝!(VBA寫法轉成函數寫法) [打印本頁]

---

作者: chiang0320    時間: 2016-5-2 12:44     標題: IF多重判斷，請幫忙，謝謝!(VBA寫法轉成函數寫法)

[attach]24131[/attach]

寫在G3儲存格

將此VBA寫法改成函數寫法

If Sheets("工作表1").Cells(I, "D") < 0.5 Then

Sheets("工作表1").Cells(I, "G") = "新人"

ElseIf Sheets("工作表").Cells(I, "F") = "陳奕迅" Or Sheets("Assy1").Cells(I, "F") = "劉德華" Then

Sheets("工作表").Cells(I, "G") = "leader"

ElseIf Sheets("工作表1").Cells(I, "F") = "張學友" Or Sheets("工作表").Cells(I, "F") = "郭富城" Then

Sheets("工作表1").Cells(I, "G") = "leader(代)"

ElseIf Sheets("工作表1").Cells(I, "F") = "李焜耀" Or Sheets("工作表1").Cells(I, "F") = "郭台銘" Or Sheets("工作表1").Cells(I, "F") = "小蝦" Then

Sheets("工作表1").Cells(I, "G") = "訓練員"

ElseIf Sheets("工作表1").Cells(I, "F") = "邰智源" Or Sheets("工作表1").Cells(I, "F") = "黎明" Then

Sheets("工作表1").Cells(I, "G") = "LAB專員"

ElseIf Sheets("工作表1").Cells(I, "F") > 0.5 Then

Sheets("工作表1").Cells(I, "G") = "老鳥"

End If

Next

---

作者: 准提部林    時間: 2016-5-3 21:08

依題意, 最好建對照表, 以 VLOOKUP 取對應值,
發帖時最好連檔案也上傳, 只有文字描述或圖片, 很難獲得適切的幫助!

---

作者: ML089    時間: 2016-5-4 07:23

IF函數最多只能用7層，所以更多得層數就可以使用查詢函數如VLOOKUP、LOOKUP...等較簡單

G3=IF(D3<0.5,"新人",IFERROR(VLOOKUP(F3,{"陳奕迅","leader";"劉德華","leader";"張學友","leader(代)";"郭富城","leader(代)";"李焜耀","訓練員";"郭台銘","訓練員";"小蝦","訓練員";"邰智源","LAB專員";"黎明","LAB專員"},),"老鳥")

---

歡迎光臨 麻辣家族討論版版 (http://forum.twbts.com/)