الصيغة التالية تفي بالغرض:
=IF(OR(A13="",B13=""),"",IF(AND(A13>=13000,A13<=15000,B13>=3),40,IF(AND(A13>15000,A13<=20000,B13>=3),80,IF(AND(A13>20000,A13<=30000,B13>=3),120,IF(AND(A13>30000,A13<=40000,B13>=3),160,IF(AND(A13>40000,A13<=50000,B13>=1),200,IF(AND(A13>50000,A13<=60000,B13>=0),240,"")))))))&IF(OR(A13="",B13=""),"",IF(AND(A13>60000,A13<=70000,B13>=0),280,IF(AND(A13>70000,A13<=80000,B13>=0),320,IF(AND(A13>80000,A13<=90000,B13>=0),360,IF(AND(A13>90000,B13>=0),400,"")))))
شاهد المرفق،
________IF___AND____________7_____.rar