返回列表 上一主題 發帖

[發問] 您鍵入的公式有錯誤?(以解決，超級感謝A大H大)

ANGELA

帖子
812 
主題
7 
精華
0 
積分
862 
點名
0  
作業系統
XP 
軟體版本
2007 
閱讀權限
100 
性別
男 
來自
台中 
註冊時間
2010-5-13 
最後登錄
2019-10-10 

論壇貢獻勳章
1# 跳轉到 »
發表於 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)))

TOP

ANGELA

帖子
812 
主題
7 
精華
0 
積分
862 
點名
0  
作業系統
XP 
軟體版本
2007 
閱讀權限
100 
性別
男 
來自
台中 
註冊時間
2010-5-13 
最後登錄
2019-10-10 

論壇貢獻勳章
2#
發表於 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"})))
其實說明你的用意,會較好下手,也許可用其他公式解決,否則只好將就你的公式去瞎猜.

TOP

ANGELA

帖子
812 
主題
7 
精華
0 
積分
862 
點名
0  
作業系統
XP 
軟體版本
2007 
閱讀權限
100 
性別
男 
來自
台中 
註冊時間
2010-5-13 
最後登錄
2019-10-10 

論壇貢獻勳章
3#
發表於 2011-10-5 09:56 | 顯示全部帖子
Book1.zip (4.1 KB)
參考看看,是否是你要的.

TOP

        靜思自在 : 不要隨心所欲，要隨心教育自己。
返回列表 上一主題