求助公式:条件 【a2<90%,b2取值0.16; 90%<=a2<100%,b2取值0.13; a2=100%,b2取值0.1; 100%<a2<110%,b2取值0.8; 110%<=a2<120,b2取值0.06; a2>=120%,b2取值0】 公式b2怎么写,谢谢!
[此贴子已经被作者于2010-3-19 13:36:41编辑过]
B2=if(a2=1,0.1,CHOOSE(SUM(--(A2<{0.9,1,1.1,1.2}))+1,0,0.06,0.8,0.13,0.16))
[此贴子已经被作者于2010-3-19 13:57:23编辑过]
|