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=3
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/05 13:02:40
![IF 条件语法=IF(MAX($J2:$AR2)=MAX($AS2:AS2),](/uploads/image/z/14186626-34-6.jpg?t=IF+%E6%9D%A1%E4%BB%B6%E8%AF%AD%E6%B3%95%3DIF%28MAX%28%24J2%3A%24AR2%29%3DMAX%28%24AS2%3AAS2%29%2C%22%22%2CIF%28J2%3D1%2CK2%3D2%2CL2%3D3%2CM2%3D4%2CN2%3D5%2CO2%3D6%2CP2%3D7%2CQ2%3D8%2CR2%3D9%2CS2%3D10%2CT2%3D11%2CV2%3D12%2CW2%3D13%2CX2%3D14%2CY2%3D15%2CZ2%3D16%2CAA2%3D17%2CAB2%3D18%2CAC2%3D19%2CAD2%3D20%2CAE2%3D21%2CAF2%3D22%2CAH2%3D23%2CAI2%3D24%2CAJ2%3D25%2CAK2%3D26%2CAL2%3D27%2CAM2%3D28%2CAN2%3D29%2CAO2%3D30%2CAP2%3D31%2CAQ2%3D3)
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=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 条件语法=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=3
你那些一堆条件怎么如果是想让他同时成立怎么说也应该加个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,"