Index
Related topics:
TableLookup
TableLookup
Tutorial Videos
Tutorial videos are available here.
Knowledge Base
Visit our User Forum for discussions & solutions
April 14, 2011
TableLookup - XpressDox
The TableLookup function enables the calculation of an amount from a table. Typically this is used with tax tables, or other tables of tariffs.
The normal tax calculation for South Africa for the 2008/09 tax year is based on this table (reproduced from the South African Revenue Services web site):
Taxable income (R) |
Rate of tax (R) |
|---|---|
| 1 – 122 500 | 18% of each R1 |
| 122 5001 – 195 000 | 21 960 + 25% of the amount above 122 500 |
| 195 001 – 270 000 | 40 210 + 30% of the amount above 195 000 |
| 270 001 – 380 000 | 62 710 + 35% of the amount above 270 000 |
| 380 001 – 490 000 | 101 210 + 38% of the amount above 380 000 |
| 490 001 and above | 143 010 + 40% of the amount above 490 000 |
The TableLookup function representing this table would be:
«TableLookup(Income,“122500;0;18,195000;21960;25,270000;40210;30,380000;62710;35,
490000;101210;38,999999999;143010;40”)»
See also how to Calculate a Fee from a Table.