[請問] EXCEL函數問題:－看見台灣線上看, 看見台灣上映戲院, 看見台灣心得, 看見台灣紀錄片, 看見台灣dvd, 看見台灣原聲帶, 看見台灣下載

Blogtrottr

批踢踢實業坊 ask 板

Need cooking inspiration?

Have a passion for cooking delicious meals or need inspiration for your next dish? Daily food fares to quench your palette when you subscribe to Recipe ideas.

From our sponsors

[請問] EXCEL函數問題

Aug 16th 2013, 10:40, by random77

作者random77 (隨機加碼)

站內ask

標題[請問] EXCEL函數問題

時間Fri Aug 16 10:40:42 2013

軟體:EXCEL 版本:2007 分頁1 A B 1 1001 3 2 1002 -2 分頁2 A B 1 1001 -3 2 100 -1 分頁3 A B C D 1 1001 =VLOOKUP(A1,'1'!A$1:B$2,2,FALSE) =VLOOKUP(A1,'2'!A$1:B$2,2,FALSE) 2 1002 我的問題在D這一行(以D1為例) D1 =IF(AND(B1,C1)>0,1,0) 我以為公式跑出來的應該是0，但我的畫面卻是1(D1~D999都是1) 請問哪裡有問題，我找不到阿~ -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 114.25.229.237

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