- 送心意
老江老师
职称: ,中级会计师
2018-05-22 06:54
你好,试一下这个公式 ,其中A2是实发工资
=IF(3500<(ROUND(MAX((A2-3500-{0,105,555,1005,2755,5505,13505})/(1-{0.03,0.1,0.2,0.25,0.3,0.35,0.4}))+3500,2)),(ROUND(MAX((A2-3500-{0,105,555,1005,2755,5505,13505})/(1-{0.03,0.1,0.2,0.25,0.3,0.35,0.4}))+3500,2)),A2)
还没有符合您的答案?立即在线咨询老师 免费咨询老师
精选问题
获取全部相关问题信息