標題:
[發問]
您鍵入的公式有錯誤?(以解決，超級感謝A大H大)
[打印本頁]
作者:
av8d
時間:
2011-10-4 12:05
標題:
您鍵入的公式有錯誤?(以解決，超級感謝A大H大)
本帖最後由 av8d 於 2011-10-6 09:58 編輯
IF(B3="","",LOOKUP(,-FIND({"101","201","301","401","501","601","701","801","901","1001","1101","1201"},B3),{"1231","131","230","331","430","531","630","731","831","930","1031","1130"}),IF(ISERROR(FIND("氣球",$D3))+(ISNUMBER(FIND("氣球",$D3))*(--TEXT(C3,"00!:00")>0.5)),B3,B3-1))
可是不知道錯在哪裡?
---------------------------------------------------------------------------
8樓的H大解答了我的疑問~您所說的話~我會謹記在心的~謝謝!!
作者:
ANGELA
時間:
2011-10-4 12:55
猜是
=IF(B3="","",IF(ISERROR(LOOKUP(,-FIND({"101","201","301","401","501","601","701","801","901","1001","1101","1201"},B3),{"1231","131","230","331","430","531","630","731","831","930","1031","1130"})),IF(ISERROR(FIND("氣球",$D3))+(ISNUMBER(FIND("氣球",$D3))*(--TEXT(C3,"00!:00")>0.5)),B3,B3-1)))
作者:
av8d
時間:
2011-10-4 15:22
本帖最後由 av8d 於 2011-10-4 15:23 編輯
回復
2#
ANGELA
謝謝大大~我想詢問一下~是函數下錯嗎?
為什麼他是FALSE 我要的答案是1231
[attach]8084[/attach]
作者:
ANGELA
時間:
2011-10-4 16:09
本帖最後由 ANGELA 於 2011-10-4 16:16 編輯
=IF(B3="","",IF(ISERROR(LOOKUP(,-FIND({"101","201","301","401","501","601","701","801","901","1001","1101","1201"},B3),{"1231","131","230","331","430","531","630","731","831","930","1031","1130"})),IF(ISERROR(FIND("氣球",$D3))+(ISNUMBER(FIND("氣球",$D3))*(--TEXT(C3,"00!:00")>0.5)),B3,B3-1),--LOOKUP(,-FIND({"101","201","301","401","501","601","701","801","901","1001","1101","1201"},B3),{"1231","131","230","331","430","531","630","731","831","930","1031","1130"})))
其實說明你的用意,會較好下手,也許可用其他公式解決,否則只好將就你的公式去瞎猜.
作者:
av8d
時間:
2011-10-5 08:43
回復
4#
ANGELA
大大您好~在此說明我的用意~再次感謝~您真的好厲害~可是好像是我自己寫錯~詳細說明如下!
=IF(ISERROR(FIND("氣球",$D3))+(ISNUMBER(FIND("氣球",$D3))*(--TEXT(C3,"00!:00")>0.5)),B3,B3-1)
原用意為：當D欄出現氣球的時候~去判斷C欄是否超過50%如果超過就填上B欄位~若低於50%他就會填上B欄的值-1
但是我現在要在B欄-1(如下)這個地方在做的時候判斷B欄是否為101,201,301,401.......1201然後去對應直接填入1231,131,230,331........1130
=IF(ISERROR(FIND("氣球",$D3))+(ISNUMBER(FIND("氣球",$D3))*(--TEXT(C3,"00!:00")>0.5)),B3,
B3-1
)
可是我判斷式下錯了~目前還沒出現我要的值~再次感謝大大多次協助!!
作者:
ANGELA
時間:
2011-10-5 09:56
[attach]8096[/attach]
參考看看,是否是你要的.
作者:
av8d
時間:
2011-10-5 20:34
本帖最後由 av8d 於 2011-10-5 20:39 編輯
回復
6#
ANGELA
大大~不好意思喔~由於必須輸入方便~不可以更改自訂方式~
他的判斷有誤~當日期是1號~他的判斷應該是先判斷目前是否有氣球~時間是否在12點以前~
如果是~就顯示月底~如果是12點以後~就顯示當天~但是他依然顯示月底!
我想知道如何在函數中在做判斷~像是寫VBA那樣!
作者:
Hsieh
時間:
2011-10-5 22:54
回復
7#
av8d
資料要這樣玩是自找麻煩
G3=IF(B3="","",IF(ISERROR(FIND("氣球",$D3))+(ISNUMBER(FIND("氣球",$D3))*(--TEXT(C3,"00!:00")>0.5)),--TEXT(TEXT(B3,"00!/00"),"mdd"),--TEXT(TEXT(B3,"00!/00")-1,"mdd")))
歡迎光臨 麻辣家族討論版版 (http://forum.twbts.com/)
