IF 条件语法=IF(MAX($J2:$AR2)=MAX($AS2:AS2),"",IF(J2=1,K2=2,L2=3,
IF 条件语法
=IF(MAX($J2:$AR2)=MAX($AS2:AS2),"",IF(J2=1,K2=2,L2=3,M2=4,N2=5,O2=6,P2=7,Q2=8,R2=9,S2=10,T2=11,V2=12,W2=13,X2=14,Y2=15,Z2=16,AA2=17,AB2=18,AC2=19,AD2=20,AE2=21,AF2=22,AH2=23,AI2=24,AJ2=25,AK2=26,AL2=27,AM2=28,AN2=29,AO2=30,AP2=31,AQ2=32,AR2=33,"",SMALL($J2:$AR2,COUNTIF($J2:$AR2,"
=IF(MAX($J2:$AR2)=MAX($AS2:AS2),"",IF(J2=1,K2=2,L2=3,M2=4,N2=5,O2=6,P2=7,Q2=8,R2=9,S2=10,T2=11,V2=12,W2=13,X2=14,Y2=15,Z2=16,AA2=17,AB2=18,AC2=19,AD2=20,AE2=21,AF2=22,AH2=23,AI2=24,AJ2=25,AK2=26,AL2=27,AM2=28,AN2=29,AO2=30,AP2=31,AQ2=32,AR2=33,"",SMALL($J2:$AR2,COUNTIF($J2:$AR2,"
赞 牙獠 幼苗
共回答了22个问题采纳率：95.5% 举报
你那些一堆条件怎么如果是想让他同时成立怎么说也应该加个and语句吧,不然你那就不符合if语句格式=IF(MAX($J2:$AR2)=MAX($AS2:AS2),"",IF(and(J2=1,K2=2,L2=3,M2=4,N2=5,O2=6,P2=7,Q2=8,R2=9,S2=10,T2=11,V2=12,W2=13,X2=14,Y2=15,Z2=16,AA2=17,AB2=18,AC2=19,AD2=20,AE2=21,AF2=22,AH2=23,AI2=24,AJ2=25,AK2=26,AL2=27,AM2=28,AN2=29,AO2=30,AP2=31,AQ2=32,AR2=33),"",SMALL($J2:$AR2,COUNTIF($J2:$AR2,"
1年前
5
可能相似的问题
-
1年前1个回答
-
1年前1个回答
-
1年前2个回答
你能帮帮他们吗