close
Blogtrottr
批踢踢實業坊 ask 板
 
Own the Game.

Elevate your game with the newest adidas men's soccer footwear and apparel.
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
arrow
arrow
    全站熱搜
    創作者介紹
    創作者 acer4 的頭像
    acer4

    2016令你難忘的必看韓劇大推薦 電視劇。韓劇│ 2015 上半年 韓劇推薦 劇情超驚喜 必看韓劇清單 必追韓劇

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

    E-mail轉寄