how to calculate net pay in excel

Watch your pay stub to identify which deductions are pre-tax or post-tax. Moreover, the basic salary of an employee should be at least 50-60% of his/her gross salary.