IF(AND(OR(走货航班号="ZH9103",走货航班号="ZH9105"),IF(走货航班号="ZH9103"",自主编号〈排名文本最大值赋值〉,0)+IF(走货航班号="ZH9105",自主编号〈排名文本最大值赋值》,0)<=3),1500, IF(AND(OR(走货航班号=ZH9103",走货航班号="ZH9105""),IF(走货航班号="ZH9103",自主编号〈排名文本最大值赋值》,0)+IF(走货航班号="ZH9105",自主编号〈排名文本最大值赋值》,0)>3),超重重里*运价, -------------------------------------------- 我想写的逻辑是这样: 如果航班号9103的编号+9105的编号小于等于3 则费用按1500算, 如果航班号9103的编号+9105的编号大于3 则超重重里*运价, ------------------- |