耀宗 asked in 電腦與網際網路軟體 · 1 decade ago

可以教我Excel函數CHOOSE的用法嗎?

我忘記Excel函數當中IF和CHOOSE的用法~

請問有人可以教我用嗎?

最好是有範例更好~謝謝!

2 Answers

Rating
  • masa
    Lv 6
    1 decade ago
    Favorite Answer

    依a1的值視為中奬號碼,往後兌奬,奬品數最多29項,且奬品個數不可少於a1

    =choose(a1,"陳一","老二","張三","李四","王五","60元",700,800,.....)

    如a1=3,則兌選往後第三個為"張三"

    如a1=3+4 (7), 則傳回第7個值 700

    依a1的值為名次,(a1的值限1至29)

    往後選取第幾個參數傳回,

    a1 後面參數的個數最多可29個,且個數不可少於a1的值,

    够明白嗎

Still have questions? Get your answers by asking now.