急求计算奖金公式,姓名 业绩 职位 12％ 14％ 16％ 18％ 20％ 22％ 36％ 韩 35960 物业顾问 张 25000 高注：物业顾问奖金比例起点12％,分段比例,35960＝12000＋8000＋8000＋7980,即：奖金＝12000×12％＋8000×

急求计算奖金公式,姓名 业绩 职位 12％ 14％ 16％ 18％ 20％ 22％ 36％ 韩 35960 物业顾问 张 25000 高注：物业顾问奖金比例起点12％,分段比例,35960＝12000＋8000＋8000＋7980,即：奖金＝12000×12％＋8000×
急求计算奖金公式,
姓名 业绩 职位 12％ 14％ 16％ 18％ 20％ 22％ 36％
韩 35960 物业顾问
张 25000 高
注：物业顾问奖金比例起点12％,分段比例,35960＝12000＋8000＋8000＋7980,即：奖金＝12000×12％＋8000×14％＋8000×16％＋7980×18％
高物起点14％.
13761523535,梅小姐，找精通EXCEL的老师！

急求计算奖金公式,姓名 业绩 职位 12％ 14％ 16％ 18％ 20％ 22％ 36％ 韩 35960 物业顾问 张 25000 高注：物业顾问奖金比例起点12％,分段比例,35960＝12000＋8000＋8000＋7980,即：奖金＝12000×12％＋8000×
档次表
职务 0.12 0.14 0.16 0.18 0.2 0.22 0.36
物业顾问 12000 8000 8000 8000 8000 8000 8000
高 0 8000 8000 8000 8000 8000 8000
奖金表
姓名 业绩 职位 0.12 0.14 0.16 0.18 0.2 0.22 0.36 奖金
韩 35960 物业顾问 =IF(SUM(B7,-B3)>0,B3*B$2,IF(SUM(B7,0)>0,SUM(B7,0)*B$2,0)) =IF(SUM(B7,-B3,-C3)>0,C3*C$2,IF(SUM(B7,-B3)>0,SUM(B7,-B3)*C$2,0)) =IF(SUM(B7,-B3,-C3,-D3)>0,D3*D$2,IF(SUM(B7,-B3,-C3)>0,SUM(B7,-B3,-C3)*D$2,0)) =IF(SUM(B7,-B3,-C3,-D3,-E3)>0,E3*E$2,IF(SUM(B7,-B3,-C3,-D3)>0,SUM(B7,-B3,-C3,-D3)*E$2,0)) =IF(SUM(B7,-B3,-C3,-D3,-E3,-F3)>0,F3*F$2,IF(SUM(B7,-B3,-C3,-D3,-E3)>0,SUM(B7,-B3,-C3,-D3,-E3)*F$2,0)) =IF(SUM(B7,-B3,-C3,-D3,-E3,-F3,-G3)>0,G3*G$2,IF(SUM(B7,-B3,-C3,-D3,-E3,-F3)>0,SUM(B7,-B3,-C3,-D3,-E3,-F3)*G$2,0)) =IF(SUM(B7,-B3,-C3,-D3,-E3,-F3,-G3,-H3)>0,H3*H$2,IF(SUM(B7,-B3,-C3,-D3,-E3,-F3,-G3)>0,SUM(B7,-B3,-C3,-D3,-E3,-F3,-G3)*H$2,0)) =SUM(D7:J7)
张 25000 高 =IF(SUM(B8,-B4)>0,B4*B$2,IF(SUM(B8,0)>0,SUM(B8,0)*B$2,0)) =IF(SUM(B8,-B4,-C4)>0,C4*C$2,IF(SUM(B8,-B4)>0,SUM(B8,-B4)*C$2,0)) =IF(SUM(B8,-B4,-C4,-D4)>0,D4*D$2,IF(SUM(B8,-B4,-C4)>0,SUM(B8,-B4,-C4)*D$2,0)) =IF(SUM(B8,-B4,-C4,-D4,-E4)>0,E4*E$2,IF(SUM(B8,-B4,-C4,-D4)>0,SUM(B8,-B4,-C4,-D4)*E$2,0)) =IF(SUM(B8,-B4,-C4,-D4,-E4,-F4)>0,F4*F$2,IF(SUM(B8,-B4,-C4,-D4,-E4)>0,SUM(B8,-B4,-C4,-D4,-E4)*F$2,0)) =IF(SUM(B8,-B4,-C4,-D4,-E4,-F4,-G4)>0,G4*G$2,IF(SUM(B8,-B4,-C4,-D4,-E4,-F4)>0,SUM(B8,-B4,-C4,-D4,-E4,-F4)*G$2,0)) =IF(SUM(B8,-B4,-C4,-D4,-E4,-F4,-G4,-H4)>0,H4*H$2,IF(SUM(B8,-B4,-C4,-D4,-E4,-F4,-G4)>0,SUM(B8,-B4,-C4,-D4,-E4,-F4,-G4)*H$2,0)) =SUM(D8:J8)

问题没有描述清楚，你的1200、8000……是哪里来的？没法告诉你公式

是EXCEL里的公式吧，具体是什么样的说清楚点。应该很简单