Use Google to find help fast. For example, search on "xpressdox choosefromlist".

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