多条件求计算结果 (9123)

P6:S9=IFERROR(IF((MATCH(P$5,$M6:$N6,)=1)*($M6<>$N6),0.01,($E6="oo五")*0.03+0.02)*((MATCH(P$5,$M6:$N6,)=1)*($M6<>$N6)*$H6+$I6),"")

另解=IF(P$5=$N6,$I6*(0.02+0.03*($E6="oo五")),IF(P$5=$M6,($H6+$I6)*0.01,""))