[請問] 尋求Excel函數答人:－2016 台北日本料理推薦 , 台北日本料理吃到飽 , 台北日本料理名店 , 台北日本料理吃到飽推薦 , 台北日本料理推薦2014

Blogtrottr

批踢踢實業坊 ask 板

Aug 4th 2013, 19:51, by rsandylimo

作者rsandylimo (Andy結婚禮車/瑞陞租車)

看板ask

標題[請問] 尋求Excel函數答人

時間Sun Aug 4 19:51:44 2013

假設（A>L）調車人日期時間類型行程聯絡人電話現金簽單陳 3150 江 03150 假設調車人為陳，現金為0，函數可帶出，陳生簽單調車人為江，現金為0，函數可帶出，江生簽單調車人為陳，現金為100，簽單0，函數可帶出，收現100 調車人為陳，現金為100，簽單為50，函數可帶出，收現100+陳生簽單請問以上條件有辦法在EXCEL用函數做嗎？目前我僅能做出 =IF(AND(A2="陳",K2=0),"。陳生簽單，謝謝",(CONCATENATE("。收現",K2,"，謝謝"))) 可以把兩個同樣一if公式，但條件不同，設在同一個格子裡嗎？ -- Sent from my Android -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 101.11.129.175

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