Name khan fawad hussain samad qais jamil ahmad ajmal raheem
Post Salary teacher 1 teacher 2 teacher 3 teacher 4 doctor 5 doctor 7 doctor 6 engineer 1000 clerk 200
Serial 1 2 3 4 5 6 7
Year Lahore Multan Pindi Peshawar 2000 100 500 300 1000 2001 200 600 700 900 2002 300 700 1100 800 2003 400 800 1500 700 2004 500 900 1900 600 2005 600 1000 2300 500 2006 700 1100 2700 400
Value multan Row Number 4 Result 800
Items Barrings
Value Tax 20000
0.05
Deducted_Amount Net_Value 1000 19000
Value 1000 100000 1000000 10000000 500000000
Tax 5% 7% 10% 12% 15%
H lookup Serial
Year 1 2 3 4 5 6 7 8 9 10
2000 2001 2002 2003 2004 2005 2006 2007 2008 2009
Value Row number Result
Lahore Multan Pindi Peshawar 200000 300000 100000 70000 400000 400000 200000 80000 600000 500000 300000 90000 550000 600000 400000 100000 560000 700000 500000 110000 300000 800000 600000 120000 250000 900000 700000 130000 650000 1000000 800000 140000 340000 1100000 900000 150000 900000 1200000 1000000 160000
Multan 3 500000
Taxation Table Item Value Tax Scowter 50000 Motor cycle 100000 Car 500000 Fajaroo 1000000 Tank 10000000 boycycle 5000 Kamaz 1000000
0.08 0.10 0.10 0.12 0.15 0.05 0.12
Deducted_Amount Net_Value 4000 46000 10000 90000 50000 450000 120000 880000 1500000 8500000 250 4750 120000 880000 0 0 0 0 0 0 0 0 0 0 0 0
Value 1000 10000 100000 1000000 10000000 50000000 100000000
Tax Rate 5% 8% 10% 12% 15% 18% 20%