How to create a data entry form in Excel that includes math formulas
This data entry form is very similar to the previous post (Student data entry) except this time we're going to create this data entry form to work related tasks. If you don't know how to enable the data entry form in Excel visit the previous
1. In the meantime, write down the categories as seen on the picture below and insert as a table. Now we're going to integrate a couple of math formulas on some of the cells. So under the Total Salary cell write down the formula =F2+G2
2. Step two, we're going to type the formula for the tax deduction. What you need to do is just under the Tax Deduction cell write down =H2*18% , that is going to calculate us the 18% tax of the total salary.
3.Step three, under the Net Salary cell write down the formula =H2-I2 .
4. Step four, once you open the data entry form window you'll notice that the fields containing total salary, tax deduction and net salary are locked from typing any data, and that's because we've already inputted the formulas on those fields (cells). So as in the previous post, from now on it's pretty simple just write down the information required and click new.
Final table look.
Here's also a video on how to make this data entry form...
Comments
Post a Comment