Employe
=AND(LEN(A4)=4,LEFT(A4,1)="E",COUNTIF($A$4:$A$8,A4)=1,ISNUMBER(VALUE(RIGHT(A4,3))))

Tax Amount
=B4*D4%

Total Deduction
=E4+F4

Gross Salary
=B4+C4

Net Salary
=H4-G4

Type [2nd Table]
=IF(C11="Income","-",IF(E4>B4*10%,"Over Deduct","In Range Deduct"))

Budget Range
=IF(C11="Income","-",IF(E4>B4*10%,"Over Deduct","In Range Deduct"))