XpressDox Help Center

Use Google To Find Help Fast, e.g. xpressdox choosefromlist


Press Getting Started in the XpressDox toolbar for basic template development
Watch the tutorial videos
View command help from list of commands
Press F1 for help on a command in the Command Editor
Email support@xpressdox.com for assistance

The TableLookup Function


The TableLookup Function

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.

Leave a Reply