STATISTICAL IF
| TAX CAL CULATION | TAX SLAB | |||||
| NAME | ANNUAL INCOME | TAX | FIRST | 100000 | 0% | |
| RAM | 1000000 | 310000 | NEXT | 100000 | 10% | |
| SHAM | 100000 | 0 | NEXT | 100000 | 20% | |
| LINA | 250000 | 20000 | NEXT | 100000 | 30% | |
| MANGESH | 350000 | 45000 | NEXT | 500000 | 40% | |
| JOHN | 850000 | 240000 | OTHER | 50% | ||
| ALI | 0 | |||||
| IF(B15<=100000,0%,IF(B15<=200000,(B15-100000)*10%,IF(B15<=300000,0+10000+(B15-200000)*20%,IF(B15<=400000,0+10000+20000+(B15-300000)*30%,IF(B15<=900000,0+10000+20000+30000+(B15-400000)*40%,0+10000+20000+30000+200000+(B15-900000)*50%))))) | ||||||
No comments:
Post a Comment