Skip to main content

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

income tax calculation employees formulas excel
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

Popular posts from this blog

Basic Structure of HTML Document

Basic Structure of HTML Document  The basic structure of an HTML document is given below: <HTML>         <HEAD>                  </HEAD>                 <BODY>                </BODY> </HTML> The above format shows that an HTML document starts with <HTML> tag and ends with </HTML> tag. It is also clear that an HTML document consists of two main sections:  Head Section Head section is used to specify a title of the web page, normally. There are some other uses of Head section too, like linking external style sheets and Java script code, etc. Head section starts with the <HEAD> tag and ends with the </HEAD> tag. <TITLE> tag is used to display a title of...

What are Different Types of Input Devices With Examples

Topic: Different types of input devices of a computer system with examples, pictures and explanation:  Topics Covered are: Definition of Input Devices Functions of Input Devices ( How input devices work? ) Examples of Input Devices Pictures / Images of different input devices Different Examples of Input Devices With Description Keybboard Mouse Trach Ball Trackpad Joy Stick Light Pen Microphone Scanner Graphic Tablet ( Digitizer ) Digital Camera Touch Screen ( I/O Device / Dual Device - Perform Both Functions input + Output ) INPUT DEVICES ( Definition ) Input devices are used to enter data and instructions into computer memory from external world. Input Device is a hardware part of the computer that is used to enter data and instructions into computer memory. The examples of input devices include: Keyboard, Mouse , Track ball, Track Pad, Joy stick, Touch Screen, Light pen,   Scanner , Digital Camera, Microphone, Graphics tablet e...

Microsoft Security Essentials Free Antivirus

Microsoft Security Essentials provides real-time protection for your home PC that guards against viruses, spyware, and other malicious software. Microsoft Security Essentials is a free download from Microsoft that is simple to install, easy to use, and always kept up to date so you can be assured your PC is protected by the latest technology.  Microsoft Security Essentials came into existence as Microsoft's first attempt of a standalone security application for home use. Although it has a simple user interface suitable for beginners, it probably isn't the best choice for more advanced users or professional network administrators, but for the average user, it covers all the bases. Bear in mind, however, that Microsoft Security Essentials doesn't disinfect files - it only deletes them in case of infection. It can be dangerous, if the files are important and contain precious data like financial transaction records or business sale purchase data. System Requirements: ...