第1个回答 2013-02-15
假设写在单元格A1单元格的结果
= IF(A1 <95000 IF(A1 <150000,0.01 IF(A1 <190000,0.015,0.02)))
= LOOKUP(A1, {0,0; 95000,0.01 150000,0.015 190000,0.02})
= LOOKUP(A1,{0,9.5,15,19} * 10000,{0,1单元格的格式, 1.5,2}%)
然后设置为一个百分比格式本回答被网友采纳
第2个回答 2013-02-05
假设业绩写在A1单元格
=IF(A1<95000,,IF(A1<150000,0.01,IF(A1<190000,0.015,0.02)))
或
=LOOKUP(A1,{0,0;95000,0.01;150000,0.015;190000,0.02})
=LOOKUP(A1,{0,9.5,15,19}*10000,{0,1,1.5,2}%)
再设置单元格格式为百分比格式
第3个回答 2013-02-05
=MAX(,(A1-95000)*{1,1.5,2}%-{0,275,750})