多元函数的真问题
d列公式:
= IF(OR(A2 =“A”，A2 =“B”，A2 =“C”，A2 =“D”，A2 =“E”，A2 =“F”)，C2*0.02，IF(A2 =“G”，C2*0.03，IF(OR(A2 =“H”，A2 =“I”)，IF(B2 & gt；=0.28，C2*0.04，C2*0.02))))
结果如图所示:
= IF(OR(A2 =“A”，A2 =“B”，A2 =“C”，A2 =“D”，A2 =“E”，A2 =“F”)，C2*0.02，IF(A2 =“G”，C2*0.03，IF(OR(A2 =“H”，A2 =“I”)，IF(B2 & gt；=0.28，C2*0.04，C2*0.02))))
结果如图所示: