Method 1: Employee Database & Basic Salary Structure The figure below showsbasic salarystructure of a company, and we want to calculate the net salary by adding allowances and subtracting deductions. Method 2 – Create Allowance and Deduction Structure The figure shows the allowance percentages of ...
Step 5 – Calculate PF, Tax & TDS and Deduct Them from Gross Salary Add columns on the right side for the deductions. Calculate thePFbased on theBasic Salary–9%. Enter the following formula inT6. =ROUNDUP($M6*9%,0) PressEnterand drag theFill Handle. Enter a formula to calculate the...
In the rows below the named columns, enter the date, number of hours you’ve worked, and the amount you made. Leave the cells under “Hourly Rate” blank.“Thankfully, it only takes a few simple steps to calculate your hourly salary in Excel.” ...
Step 2 – Suppose you’re seeking to retrieve the salary of an employee named “James.” This name will serve as your lookup value and also pick a cell in your Excel sheet where you’d like to use VLOOKUP, just like in the image. Step 3 – The table range should include the entire...
Input validation:The next step in the process is checking the validity of the input data and whether it adheres to company policy. This is the time to make sure no active employee has been missed and no inactive employee has been included in the salary payment. ...
Excel is a vital tool that is widely used in every business operation. It can easily format, arrange, calculate, analyze and organize data in a spreadsheet. Vlookup, which stands for “Vertical, look up” is an Excel built-in function. It is used to locate (look up) a value from one...
Assume you have the following data in an Excel sheet: To find the salary of a specific employee in a particular department, such as "Michael" in the "HR" department, follow these steps: Step 1:Understand the Data Structure Ensure you have the data set up as shown in the table above. ...
@page "/Excel" @using System.IO; @using ServerSideApplication; @inject ServerSideApplication.Data.ExcelService service @inject Microsoft.JSInterop.IJSRuntime JS Step 2:Add the following code to create a new button (Create Document) in your application. ...
To do payroll in the free template of excel shown above, you need employee details like Date of Joining, and Date of Exit. If the candidate is still with the company, mark it as ‘Y’ Keep Salary structure details handy like Basic Salary, DA (Dearness Allowance), HRA (House Rent Allow...
The vlookup function should now retrieve the salary of John, which is 50,000. Here's how the formula works: In the first argument, "John" is the search key, which is the value you want to look up in the leftmost column of the table. In the second argument, "A:B" is the range ...