急求计算奖金公式,姓名 业绩 职位 12% 14% 16% 18% 20% 22% 36% 韩 35960 物业顾问 张 25000 高注:物业顾问奖金比例起点12%,分段比例,35960=12000+8000+8000+7980,即:奖金=12000×12%+8000×
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/06 14:27:47
![急求计算奖金公式,姓名 业绩 职位 12% 14% 16% 18% 20% 22% 36% 韩 35960 物业顾问 张 25000 高注:物业顾问奖金比例起点12%,分段比例,35960=12000+8000+8000+7980,即:奖金=12000×12%+8000×](/uploads/image/z/12124090-10-0.jpg?t=%E6%80%A5%E6%B1%82%E8%AE%A1%E7%AE%97%E5%A5%96%E9%87%91%E5%85%AC%E5%BC%8F%2C%E5%A7%93%E5%90%8D+%E4%B8%9A%E7%BB%A9+%E8%81%8C%E4%BD%8D+12%EF%BC%85+14%EF%BC%85+16%EF%BC%85+18%EF%BC%85+20%EF%BC%85+22%EF%BC%85+36%EF%BC%85+%E9%9F%A9+35960+%E7%89%A9%E4%B8%9A%E9%A1%BE%E9%97%AE+%E5%BC%A0+25000+%E9%AB%98%E6%B3%A8%EF%BC%9A%E7%89%A9%E4%B8%9A%E9%A1%BE%E9%97%AE%E5%A5%96%E9%87%91%E6%AF%94%E4%BE%8B%E8%B5%B7%E7%82%B912%EF%BC%85%2C%E5%88%86%E6%AE%B5%E6%AF%94%E4%BE%8B%2C35960%EF%BC%9D12000%EF%BC%8B8000%EF%BC%8B8000%EF%BC%8B7980%2C%E5%8D%B3%EF%BC%9A%E5%A5%96%E9%87%91%EF%BC%9D12000%C3%9712%EF%BC%85%EF%BC%8B8000%C3%97)
急求计算奖金公式,姓名 业绩 职位 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里的公式吧,具体是什么样的说清楚点。应该很简单