# 查看完整版本 : excel問題

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

=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]原帖由 [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]

=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]

[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]

=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]

:smile_o12: