你即將離開本站

並前往https://superuser.com/questions/1720285/excel-switch-statement-with-ranges

Excel Switch Statement with Ranges - Super User

Use CHOOSE/MATCH: =CHOOSE(MATCH(BT2,{0,1.5,4.5,9.5,19.5}),"Low","Limited","Moderate","Considerable","High").

確定！ 回上一頁

查詢 「Excel SWITCH case」的人也找了：

  1. excel switch用法
    2.
  2. excel case when用法
    3.
  3. excel沒有switch
    4.
  4. Excel case IF
    5.
  5. excel if多條件
    6.
  6. Excel SWITCH 2016
    7.
  7. Excel SWITCH 2013
    8.
  8. Excel case function
    9.