[請問] EXCEL函數問題:－線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

Blogtrottr

批踢踢實業坊 ask 板

Find Unique T-shirts

Explore the most popular t-shirts on Cafepress. Discover great designs celebrating anything you can think of.

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