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

Uses Of Computer In Education Field

Computer can be used in education in the following ways: Computers In Teaching and Learning Process ( Computer Aided Learning - CAL ) Computers are being used actively in educational institutes to improve the learning process. Teachers can use audio video aids through computer to prepare lesson plans. They can use Microsoft Power Point to prepare electronic presentations about their lectures. These electronic presentations will be displayed on multimedia projectors in class rooms. This will be interesting and easy to learn for students. Multimedia presentations are easy to deliver for teachers too, These presentations save a lot of effort and time. Moreover multimedia presentations are interesting to view and hear sound and visual effects. Computers will be helpful for: Instructing the students using PowerPoint slides, Word documents or Web pages and using hyperlinks for be...

Types Of Network Topology

Today, we will types of network topology . What is a Network Topology? Definition of Network topology is the shape of the network . It is the physical layout of connected devices in a network. It tells us how a network will look like. Network Topology ( Definition 2) : The way in which the connections are made among all the network entities is called the topology of the network. Network Topology ( Definition 3) :Network topology specifically refers to the physical layout of the network, e.g., the location of the computers and how the cable is run between them. Network Topology ( Definition 4) :The physical topology of a network refers to the configuration of cables, computers, and other peripherals. The characteristics of a network depend upon the network topology selected. types of network topology Explain different types of network Topology Different network topologies are as follows: 1. Bus Topology 2. Ring Topology 3. Star Topology 4. Tree Topolo...

Explain Difference Between Compiler and Interpreter

Difference between Compiler and Interpreter The Compiler and Interpreter are the two main types of Language Translator or Language Processor Explain some important differences between Compiler and Interpreter or Differentiate between Interpreter and Compiler Compiler Interpreter 1. Compiler converts a source program into machine code as a whole. 1. Interpreter converts a source program into machine code one statement at a time. 2. Compiler after translating whole...

Perfect Computer Notes

Search This Blog