How To Create Income Tax Calculation Excel Worksheet

Microsoft Excel may be used to prepare employee pay sheet with Basic pay, medical allowance, conveyance allowance, house rent and income tax entries. Each of the mentioned entries in worksheet will be calculated automatically using functions and custom formulas applied to required cells in worksheet.

income tax calculation employees formulas excel

Income Tax calculation Formulas Calculate pay of employee using income tax in Excel

After entering the sample data in the worksheet, following formulas will be applied:

Q: Create an MS Excel Worksheet to calculate Net Pay of Employees. Input is EmpID, Name, Job
and Basic Pay. Fill sample data in it as shown in the figure. Calculate Medical Allowance 10% of basic pay, House Rent 50% of basic Pay and Conveyance Allowance 30% of basic pay. Deduct income tax 5% of basic pay if basic pay is less than 30000 and income tax 10% otherwise.
BASIC FORMULAS:
Medical Allowance = D3 * 10%
House Rent = D3 * 50%
Conveyance Allowance = D3 * 10%
Income Tax = IF(D3<30000,D3*5%,D3*10%)
Net Pay = SUM(D3:G3)-H3

You would like to :

EXPLORE more Microsoft Excel Formulas for Worksheets and downloads

Electricity Bill Calculator Formulas in Excel

Microsoft Excel Formulas and Functions Fast and Easy Way -1

Using Simple Formulas in Excel With Arithmetic Operators 2

How Functions are Used in Excel Fast and Easy Way 3

Create Bar Chart in Excel Easily by Example

Employee Pay sheet Formulas in Microsoft Excel

Students Test Score Grades Result Sheet in Excel

Microsoft Office Word Processing Practicals

Comments

Types Of Headings In HTML

HTML Hedings Headings in HTML are used to display Titles, Sub-Titles of Sub-Sub-Titles for your web page text. There are six types of headings in HTML. H1 is the largest heading and H6 is the smallest heading. <H1> is opening tag whereas </H1> is the closing tag for the largest heading. The text between <h1> and </h1> will be displayed as the main Title in your web page. Following are the six tags used for six types of headings in HTML. <H1> ... </H1> <H2> ... </H2> <H3> ... </H3> <H4> ... </H4> <H5> ... </H5> <H6> ... </H6> The H1 heading is used for main titles. Actually H1 heading will show the text in largest font size. H2 headings is used for Sub-Titles. H2 displays text in smaller font size than H1, H3 displays text of font size smaller than H1 and H2, and so on. H1 is for largest heading in a text page and H6 is for smallest heading. Importance Of Headings in SEO H...

House Building Expenses Formulas in Excel

Today we will discuss the Excel Worksheet Formulas for recording Monthly House Construction Expense Management . Steps To Create Expense Management Excel Worksheet First of all, start MS Excel with a new workbook. Merge required number of cells in first row of worksheet. 3. Insert Word Art and type a suitable title heading in worksheet. 4. Enter heading row. 5. Enter data in worksheet. 6. Apply the formulas and functions in worksheet as explained later. Here is the list of expenses we have considered to be recorded. Sr. No Item 1 Cement (Bags) 2 Bricks(Trolly) 3 Sand(Trolly) 4 Gravel(Truck) 5 Iron (Kg) 6 Marble (Square Feet) 7 Electricity Bill 8 Labour 9 Miscelleaneous You can increase this list of expenses accor...

HTML Table Tag Basics

Tables Tables are very important to show data in the form of rows and columns. Tables make data more readable and easy to understand. A table consists of rows, columns and cells. HTML Tags To Make A Table As we know that there are basically three elements in a table, that is, rows, columns and cells. So, there are the following basic tags to create a table in an HTML web page: <TABLE> tag <TR> tag <TD> tag <TH> tag <TABLE> Tag <Table> tag is used to specify the start of a table. It also specifies some attributes of the table like ALIGN and BORDER attributes etc. Example 1: <Table> => Table without a border. Example 2: <Table border="1"> => Table with a border of width 1. Example 3: <Table align="left" border="2"> => A left aligned Table with a border of width 2. ...

Perfect Computer Notes

Search This Blog