单条件
min值;
=MIN(IF(A2:A5="A",B2:B5)
CTRL+SHIFT+ENTER
多条件:
=MIN(IF((A2:A8="A")*(B2:B8<4),B2:B8))
单条件
min值;
=MIN(IF(A2:A5="A",B2:B5)
CTRL+SHIFT+ENTER
多条件:
=MIN(IF((A2:A8="A")*(B2:B8<4),B2:B8))
转载于:https://www.cnblogs.com/super-yb/p/11477550.html