How to Calculate Net salary in excel 2016


Hello viewer in this tutorial we will learn how to calculate net salary in excel First See the template of excel sheet where we want to perform all these task Open Excel sheet Here you can see the employee name, post and their salary Absent days and net salary First we find out the daily salary then multiply it with absent days this will be the deduction By using formula ->Basic salary / 30 Now find out the absent days amount which is to be subtracted from the basic salary By using formula ->Basic salary / 30 * absent days this amount will be the deduction from basic salary Now subtract the deduction amount from basic salary In excel every formula must start with=symbol If you like my videos Kindly SUBSCRIBE MY CHANNEL Now find out the absent days By subtracting the net salary from basic salary If you like my videos Kindly SUBSCRIBE MY CHANNEL Copy both function bellow by dragging it down If you like my videos Kindly SUBSCRIBE MY CHANNEL

2 Replies to “How to Calculate Net salary in excel 2016

Leave a Reply

Your email address will not be published. Required fields are marked *