Anonymous
Anonymous asked in 電腦與網際網路軟體 · 8 years ago

excel 2010表單問題

請問如何設定表單如

A1 輸入"1" 則 B1 會自動顯示 "小明"

A1 輸入"2" 則 B1 會自動顯示 "小華"

以此類推

1 Answer

Rating
  • Daniel
    Lv 7
    8 years ago
    Favorite Answer

    如果填的是單純的1,2,3......等,可用CHOOSE()函數,如版大例子B1公式:

    =CHOOSE(A1,"小明","小華")

    2012-12-22 00:38:43 補充:

    如果填的是單純的1,2,3......等,可用CHOOSE()函數,如版大例子B1公式:

    =CHOOSE(A1,"小明","小華")

Still have questions? Get your answers by asking now.