What is the formula making salary system using Microsoft Excel?

Answer 1

A huge amount of formulas would be used to do a full salary system. There are various ways salary can be calculated and various factors that influence them. For these reasons your question cannot be given with a simple answer. While it is possible to do it all in a spreadsheet, because of the complexities there are special payroll applications available that will do it.

Even to do a simple salary slip is complex. The layout of it is simple, as you can put in text and draw borders etc. If you want to do the calculations, then it becomes more difficult. You need to know how to calculate the salary correctly and then do the formulas correctly. So it can be a complex process, and in different places the taxation system is different and there can be some complications in working out the correct salary. With a payroll system, all the calculations are built in whereas you have to do them all yourself in a spreadsheet. This is why a payroll system is better.