Blogtrottr
批踢踢實業坊 ask 板
 
[請問] EXCEL的寫法
Apr 27th 2014, 07:17, by iiiikkk

作者iiiikkk (東森媒體科技)

看板ask

標題[請問] EXCEL的寫法

時間Sun Apr 27 07:17:41 2014

在一堆成績裡, 我想要讓EXCEL產生以下功能不知道語法怎麼寫? 90分以上顯示A 70~89分顯示B+ 60~69分顯示B- 59分以下顯示C 感謝了~ -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 111.249.97.174 ※ 文章網址: http://www.ptt.cc/bbs/ask/M.1398554263.A.CE5.html

→ wxtab019:=LOOKUP(A1,{0,60,70,90;"C","B-","B+","A"}) 04/27 07:38

This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.
You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions
arrow
arrow
    全站熱搜

    xals2q 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄