This is a single cell formula for OLD TAX rates, no need for tables for VLOOKUP. I'll try and find the time to update to this year's rates or have a go yourself Change the cell reference as required to read your income, this one is D18
200708 Rates
=IF(D18<6001,0, IF(AND(D18>6000,D18<=30001),(D186000)*0.15, IF(AND(D18>30001,D18<75001),3600+(D1830000)*0.3, IF(AND(D18>=75001,D18<150001),17100+(D1875000)*0.4, IF(D18>=150001,47100+(D18150000)*0.45)))))
Old Rates
=IF(D18<6001,0, IF(AND(D18>6000,D18<=21601),(D186000)*0.17, IF(AND(D18>21601,D18<58001),2652+(D1821600)*0.3, IF(AND(D18>=58001,D18<70001),13572+(D1858000)*0.42, IF(D18>=70001,18612+(D1870000)*0.47)))))
Last edited by Sim; 30102007 at 08:20 AM.
Reason: 200708 tax rates
