close
Blogtrottr
批踢踢實業坊 ask 板
 
Shop the Official Crayola Store

Find art supplies for outdoor play, coloring books for indoor play and lots more. Visit our colorful online store today.
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
    全站熱搜
    創作者介紹
    創作者 candycrushsaga3 的頭像
    candycrushsaga3

    20162016韓劇推薦|討論2016韓劇推薦推薦好看的韓劇推薦與韓劇推薦2016韓劇排行榜前十名 , 好看的韓劇推薦 , 2016韓劇收視率

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

    E-mail轉寄