条件判断，求简化

2871778625

=IF(AND(F4=$AG$1,AA4>=9),"是",IF(AND(F4=$AH$1,AA4>=13),"是",IF(AND(F4=$AI$1,AA4>=15),"是",IF(AND(F4=$AJ$1,AA4>=18),"是",IF(AND(F4=$AK$1,AA4>=24),"是",IF(AND(F4=$AL$1,AA4>=28),"是",IF(AND(F4=$AM$1,AA4>=13),"是","否")))))))

山菊花

如果允许，把9、13、15……写到AG2:AM2，可用公式：
=IF(AA4>=HLOOKUP(F4,AG1:AM2,2,),"是","否")

下面两个为数组公式：
=IF(AA4>=HLOOKUP(F4,IF({1;0},AG1:AM1,{9,13,15,18,24,28,13}),2,),"是","否")
=IF(OR((F4=AG1:AM1)*(AA4>={9,13,15,18,24,28,13})),"是","否")
按Ctrl+Shift+Enter结束。

ToT5050

=IF(SUMPRODUCT((F4=$AG$1:$AM$1)*(AA4>={9,13,15,18,24,28,13})),"是","否")
我这种强迫症就喜欢做这样公式简化的事情，但还是希望你下次能传附件上来