=IF(B2='S',(IF(C2>800000,((C2-800000)*0
Department of Atomic Energy
Administrative Training Institute
Calculate Income Tax – Activity
1. Create a new MS Excel worksheet and enter the data given below:
| |A |B |C |D |
|2 |A |M |310000 | |
|3 |B |F |700000 | |
|4 |C |S |320000 | |
|5 |D |M |510000 | |
|6 |E |F |195000 | |
|7 |F |S |350000 | |
|8 |G |M |310000 | |
|9 |H |F |156000 | |
|10 |I |S |320000 | |
|11 |J |S |850000 | |
2. In Cell C2 please enter the following formula (Please do not leave any space in between or press enter key. The formula has to be entered in one stretch). Copy the formula to the remaining cells below C2
=IF(B2="S",(IF(C2>800000,((C2-800000)*0.3)+86000,IF(C2>500000,((C2-500000)*0.2)+26000,IF(C2>240000,(C2-240000)*0.1,0)))),IF(B2="f",(IF(C2>800000,((C2-800000)*0.3)+91000,IF(C2>500000,((C2-500000)*0.2)+31000,IF(C2>190000,(C2-190000)*0.1,0)))),(IF(C2>800000,((C2-800000)*0.3)+94000,IF(C2>500000,((C2-500000)*0.2)+34000,IF(C2>160000,(C2-160000)*0.1,0))))))
Note: 1 - The above calculation is based on following slabs
|Category |Income exempted from Tax |First Slab |Second Slab |Third Slab |
|Male |1,60,000 |160001 to |500001 to 800000 @ 20% |800001 and above @ 30% |
| | |500000 @ 10% | | |
|Female |1,90,000 |190001 to |500001 to 800000 @ 20% |800001 and above @ 30% |
| | |500000 @ 10% | | |
|Senior Citizen |2,40,000 |240001 to |500001 to 800000 @ 20% |800001 and above @ 30% |
| | |500000 @ 10% | | |
Note: 2 – Education Cess; Surcharge etc. as per rules.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- 0 xor if now sysdate sleep 15 0 xor z
- 0 xor if now sysdate sleep 15 0 xor z 2021 tax document
- if now sysdate sleep 15 0 10 run as administrator command prompt
- capitulo 0 xor if now sysdate sleep 15 0 xor z dos complementos
- allstate 2021 0 xor if now sysdate sleep 15 0 xor z
- windows if now sysdate sleep 15 0 run as administrator command prompt
- windows 10 0 xor if now sysdate sleep 15 0 xor z
- if now sysdate sleep 15 0 2015 used
- 0 xor if now sysdate sleep 15 0 xor z 2015 used
- if now sysdate sleep 15 0 grade reading passages pdf
- 0 xor if now sysdate sleep 15 0 xor z example of present tense
- 0 xor if now sysdate sleep 15 0 xor z example of epic story