我要站起來 2022-11-1 21:09
請問有無師兄師姐可以幫下忙
因為有四種條件
A1<B1 & A2<B2 "文字" A B
A1<B1 & A2>B2 "文字" 1 15 16
A1>B1 & A2<B2 "文字" 2 28 33
A1>B1 & A2>B2 "文字"
=IFS(C3>B3 , C4>B4, "齊貨"), ( C3<B3 , C4<B4, "未齊貨"),( C3<B3 , C4>B4, "準備出貨"),( C3>B3 , C4<B4, "已出貨")
請問有沒有公式可以做到這效果
alee001 2022-11-1 21:42
如果唔考慮有機會C3=B3及C4=B4公式如下
=IF(AND(C3>B3,C4>B4),"齊貨",IF(AND(C3<B3,C4<B4),"未齊貨",IF(AND(C3<B3,C4>B4),"準備出貨",IF(AND(C3>B3,C4<B4),"已出貨","未分類“))))
我要站起來 2022-11-1 21:47
[quote]原帖由 [i]alee001[/i] 於 2022-11-1 21:42 發表 [url=https://computer.discuss.com.hk/redirect.php?goto=findpost&pid=553382225&ptid=30841050][img]https://computer.discuss.com.hk/images/common/back.gif[/img][/url]
如果唔考慮有機會C3=B3及C4=B4公式如下
=IF(AND(C3>B3,C4>B4),"齊貨",IF(AND(C3<B3,C4<B4),"未齊貨",IF(AND(C3<B3,C4>B4),"準備出貨",IF(AND(C3>B3,C4<B4),"已出貨","未分類“)))) ... [/quote]
唔該師兄
試下先
唔該晒
我要站起來 2022-11-1 22:11
[quote]原帖由 [i]alee001[/i] 於 2022-11-1 21:42 發表 [url=https://computer.discuss.com.hk/redirect.php?goto=findpost&pid=553382225&ptid=30841050][img]https://computer.discuss.com.hk/images/common/back.gif[/img][/url]
如果唔考慮有機會C3=B3及C4=B4公式如下
=IF(AND(C3>B3,C4>B4),"齊貨",IF(AND(C3<B3,C4<B4),"未齊貨",IF(AND(C3<B3,C4>B4),"準備出貨",IF(AND(C3>B3,C4<B4),"已出貨","未分類“)))) ... [/quote]
唔該晒師兄
攪掂晒
之前我試過=IF(C3>B3 & C4>B4),"齊貨"
唔得
原來我公式錯了
唔該晒
:smile_o12: