摘要:
洗好澡还算清醒,再把很久以前给我爸写的工资条制作方法整理下。首先还是看下案例表Sheet1的结构: ABCDEF1姓名业绩底薪工龄工龄工资应发薪水2苏玟洁4500001000011500115003罗丹伶5000001500054000190004颜世璇8000001500043000180005苏俊明10000002000032500225006王思涵2500000250002200027000希望实现的效果: ABCDEF1姓名业绩底薪工龄工龄工资应发薪水2苏玟洁4500001000011500115003姓名业绩底薪工龄工龄工资应发薪水4罗丹伶5000001500054000190005 阅读全文