How to calculate tax in html table?

4 New Member

I have the following table:

Expand|Select|Wrap|Line Numbers

       0 -  40 000    0%       0

 40 001 -  80 000   27%       0

 80 001 - 200 000   32%  10 800

200 001 - 750 000   34%  49 200

750 001 -           37% 236 200

Assuming my Taxable Salary is 155 123.00 p.a, How do I calculate my tax payable with java script.(IF/Match). I all ready have written the table in html to sum all the income and deductions which gives me 155 123.00.

Thank you

May 22 '12 #1

Subscribe Reply

1975

Rabbit

12,516

Recognized Expert Moderator MVP

What code do you have so far?

May 22 '12 #2

williamje

New Member

In Javascript!!! Hope I am right. Quite new to this stuff!!!

Expand|Select|Wrap|Line Numbers

 html>

<head>

<title>MONTHLY TAX</title>

<style>

     body {

     font-size : sans-serif ;

     }

     #summation {

     font-size : 18px ;

     font-weight : bold ;

     color : black ;

     }

     .txt {

     background-color : gold ;

     font-weight : bold ;

     text-align : right ;

     }

</style>

<script type="text/javascript"><!--

function updatesum () {

document.form.sum.value= (document.form.sum1.value -0) +

(document.form.sum2.value -0) +

(document.form.sum3.value -0) +

(document.form.sum4.value -0) +

(document.form.sum5.value -0) +

(document.form.sum6.value -0) -

(document.form.sum7.value -0) ;

}

function multiply () {

var ans= (document.form.sum.value) * (document.form.twelve.value)

document.form.answer.value=ans;

}

//--></script>

</head>

<body>

<form name="form">

<table width="335" bgcolor="black">

   <caption align="left">

   <b>NAMIBIA PERSONAL INCOME TAX RATES</b>

   </caption>

   <tr bgcolor="#EDC112">

      <td align="right">0</td>

      <td align="right">40 000</td>

      <td align="right">0%</td>

      <td align="right">0</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td align="right">40 001</td>

      <td align="right">80 000</td>

      <td align="right">27%</td>

      <td align="right">0</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td align="right">80 001</td>

      <td align="right">200 000</td>

      <td align="right">32%</td>

      <td align="right">10 800</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td align="right">200 001</td>

      <td align="right">750 000</td>

      <td align="right">34%</td>

      <td align="right">49 200</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td align="right">750 001</td>

      <td>&nbsp;</td>

      <td align="right">37%</td>

      <td align="right">236 200</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td><b><u>Monthly Tax</u></b></td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td>Basic Pay</td>

      <td dir="rtl"><input name="sum1" id="sum1" type="text" size="12" maxlength="12" onchange="updatesum()"></td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td>Bonus</td>

      <td dir="rtl"><input name="sum2" id="sum2" type="text" size="12" maxlength="12" onchange="updatesum()"></td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td>Overtime</td>

      <td dir="rtl"><input name="sum3" id="sum3" type="text" size="12" maxlength="12" onchange="updatesum()"></td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td>Standby</td>

      <td dir="rtl"><input name="sum4" id="sum4" type="text" size="12" maxlength="12" onchange="updatesum()"></td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td>2/3 Housing All</td>

      <td dir="rtl"><input name="sum5" id="sum5" type="text" size="12" maxlength="12" onchange="updatesum()"></td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td>Other Income</td>

      <td dir="rtl"><input name="sum6" id="sum6" type="text" size="12" maxlength="12" onchange="updatesum()"></td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

   </tr>

   <tr bgcolor="red">

      <td bgcolor="red">Less:Pension</td>

      <td dir="rtl"><input name="sum7" id="sum7" type="text" size="12" maxlength="12" onchange="updatesum()"></td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td><b>Taxable Salary</b></td>

      <td dir="rtl"><input name="sum" id="sum" type="text" size="14" maxlength="14" readonly="true" disabled="disabled"></td>

      <td></td></td>

      <td></td></td>

   </tr>

   <tr bgcolor="#EDC112">

      <td><input name="twelve" id="twelve" type="button" disabled="true" value="12"></td>

      <td dir="rtl"><input name="answer" id="answer" type="text" size="14" maxlength="14"></td>

      <td></td>

      <td><input name="now" id="now" type="button" value="answer" onclick="multiply()" maxlength="14" size="14"></td>

   </tr>

   <tr bgcolor="#EDC112">

      <td></td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td><b>Tax Payable</b></td>

      <td dir="rtl"><input name="Tax Payable" id="Tax Payable" type="text" size="12" maxlength="12" readonly="true"></td>

      <td></td>

      <td></td>

   </tr>

   <tr bgcolor="#EDC112">

      <td>1</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td>2</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td>3</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td>4</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td>5</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td>6</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td>&nbsp;</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td>&nbsp;</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

   </tr>

   <tr bgcolor="#EDC112">

      <td>&nbsp;</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td>

      <td>&nbsp;</td></td>

   </tr>

</table>

<form/>

</body>

</html>

May 23 '12 #3

Rabbit

12,516

Recognized Expert Moderator MVP

Please use code tags when posting code.

And is it working?

May 23 '12 #4

williamje

New Member

Yes Rabbit,it is working. Where can I mail you the html page?

May 24 '12 #5

Rabbit

12,516

Recognized Expert Moderator MVP

Well, if it's working, I don't need to see the page.

May 24 '12 #6

williamje

New Member

Hi Rabbit,

Did you fully understand my question? I am missing the final part in my table,i.e." How will I match the 155 123.00(Taxable Salary) in the table to calculate the Tax Payable? with reference to the Table"

May 24 '12 #7

Rabbit

12,516

Recognized Expert Moderator MVP

Whether or not I understood your question is moot. You said it was working. Meaning you were able to resolve your own question. However, it seems that you mean what you have so far runs fine but your code is not working because it's not producing the results you want.

I will have to look at this tomorrow when I get more time.

May 24 '12 #8

by: alex | last post by:

Hi, I am looking for a way to populate an HTML table from an external local text file which looks like this: DATE/TIME LAT. LON. DEPTH. ML....

PHP

How to split up HTML table XSL??

by: ted | last post by:

Hello, I have a HTML table in my XSL that basically handles the layout of the whole page. I'm using xsl:include to split up the XSL into separate files. Is there a trick or technique to put...

.NET Framework

How do you vertically center an html table in css.

by: john T | last post by:

Is there anyway to vertically center a html table using css in such a way it does not alter the html table. When I tryied it just screws up.

HTML / CSS

How to calculate a table object's height?

by: demon | last post by:

if i give you a htmltable object , how can i calculate the table's height in browser?

C# / C Sharp

height property of HTML table

by: Sebastiano | last post by:

I have written a simple page with a 1x1 HTML table. I have set the two property height and width of the table to 100%. I have named this page test.htm and I try to see it using my IIS 5.0 (in...

ASP.NET

Referencing a datagrid control within an HTML table?

by: KatB | last post by:

Hi, in order to format my web page, I'm starting to use Flow layout so using html tables to space out controls, etc. When using grid layout, the following worked when it was just a datagrid. I...

ASP.NET

Problems with Dynamic Html Table control generation

by: Al Wilkerson | last post by:

Hey, I have a Web Form with a drop down list, textbox, and search button. When click the search button an SQL server database is queried fordata. Once I have the data in a dataset I use the...

ASP.NET

HTML table in Excel with line feed in cell

by: McKirahan | last post by:

I an using ASP to read a database table and generate an HTML table which is save via FSO with a file extension of .xls which opens up in MS-Excel. I am inserting several lines of text into a cell...

ASP / Active Server Pages

html table control vs web table control

by: Geary | last post by:

I am porting my first traditional app to a web-based app using VS2005 and ASP.NET 2.0. I have a page that will replace a data entry form. To have complete control of layout, I want to use a table...

ASP.NET

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

How to calculate tax in html table?

Similar topics