1、以下是最新的广州五险一金缴费比例、上下限，这个经常变动，需留意更新
2、先算出五险一金单位金额这里的20004是养老保险最高缴费基数，3468是养老保险最低缴费基数，0.14是养老保险单位比例，其他同理养老保险=ROUND(MIN(20004,MAX烫喇霰嘴([@缴费工资],3469))*0.14,2)=ROUND(MIN(20004,MAX(A3,3469))*0.14,2)医疗保险=ROUND(MIN(24654,MAX([@缴费工资],4931))*0.07,2)重大疾病保险=ROUND(MIN(8218,MAX([@缴费工资],8218))*0.0026,2)生育保险=ROUND(MIN(24654,MAX([@缴费工资],4931))*0.0085,2)工伤保险=ROUND(MIN(24654,MAX([@缴费工资],2100))*0.004,2)失业保险=ROUND(MIN(24654,MAX([@缴费工资],2100))*0.0048,2)住房公积金=ROUND(MIN(24654,MAX([@缴费工资],2100))*0.05,0)
3、合计五险一金单位金额五险一金合计=SUM(五险一金[@[养老保险]:[住房公积金]])=SUM(B3:H3)
4、再算出三险一金个人金额养老保险2 =ROUND(MIN(20004,MAX([@缴费工资],3469))忮氽阝另*0.08,2)医疗保险2 =ROUND(MIN(24654,MAX([@缴费工资],4931))*0.02,2)失业保险2 =ROUND(MIN(24654,MAX([@缴费工资],2100))*0.002,2)住房公积金2 =ROUND(MIN(24654,MAX([@缴费工资],2100))*0.1,0)
5、合计三险一金金额三险一金合计 =SUM(五险一金[@[养老保险2]:[住房公积金2]])=SUM(J3:M3)
6、大功告成
