close
Blogtrottr
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中 
2013 Ski and Snowboard gear is on sale now.

Get ready for Spring with new arrivals and wake gear. Shop today.
From our sponsors
請問一個Excel 的IF & Or問題
Aug 14th 2013, 03:06

我想要在某一儲存格設函數判斷D2這儲存格的前三碼是否為ABC或是123或是甲乙丙，若是的話就顯示Y，若不是的話就顯示空格

不知道我可以怎麼寫這函數?下方這個為什麼不行呢???

=IF(LEFT(D2,3)=OR("ABC","123","甲乙丙"),"Y","")

請高手幫解一下!!謝謝!!

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. Five Filters recommends: 'You Say What You Like, Because They Like What You Say' - http://www.medialens.org/index.php/alerts/alert-archive/alerts-2013/731-you-say-what-you-like-because-they-like-what-you-say.html
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
    全站熱搜
    創作者介紹
    創作者 miokoks 的頭像
    miokoks

    線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

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

    E-mail轉寄