广州五险一金缴费比例、上下限、计算公式
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大功告成end 20210311