返回列表 上一主題 發帖

[發問] 如何將多個IF化繁為簡?

[發問] 如何將多個IF化繁為簡?

  1. If [B5] = 1 Then Look1
  2.     If [B5] = 2 Then Look2
  3.     If [B5] = 3 Then Look3
  4.     If [B5] = 4 Then Look4
  5.     If [B5] = 5 Then Look5
  6.     If [B5] = 6 Then Look6
  7.     If [B5] = 7 Then Look7
  8.     If [B5] = 8 Then Look8
  9.     If [B5] = 9 Then Look9
  10.     If [B5] = 10 Then Look10
  11.     If [B5] = 11 Then Look11
  12.     If [B5] = 12 Then Look12
  13.     If [B5] = 13 Then Look13
  14.     If [B5] = 14 Then Look14
  15.     If [B5] = 15 Then Look15
  16.     If [B5] = 16 Then Look16
複製代碼
再次感謝!

        靜思自在 : 發脾氣是短暫的發瘋。
返回列表 上一主題