It seems that you need to use IF statements. Unfortunately I am not able to understand your conditions etc. But the basic idea would be
=IF(AND(OR(A1="model a",A1="model b",A1="model c",A1="model d"),B1<2),59, IF(AND(OR(A1="model e",A1="model f",A1="model g",A1="model h",A1="model i"),B1<2), 60, IF( AND(C1>=8, C1<=11), 1000, IF(C1>12, 1500,0) )))
Could you please upload a sample file with sample data etc on some shared site like
http://www.speedyshare.com/ and post back here the link to allow better understanding of how it is now and how you foresee.
i just updated the file, here the link :http://www.speedyshare.com/files/22232906/Sample_1.xls
refer to O22, the answer become o, it should be 1000, how to solve it.
Thanks
=IF(AND(OR(A7>=2, B7>=2,C7>=2,D7>=2), OR(E7>=2,F7>=2, G7>=2,H7>=2,I7>=2, J7>=2)),IF(AND(K7>=8,K7<=11),1000,IF(K7>=12,1500,0)),0)
thanks