Professional Tax Excel Formula
Advance Search Feature
Available Downloads - Page 1
Search Result For "Professional Tax Excel Formula" - Page 1
Hi Debanjana Raha,The PTax formula for West Bengal is as follows:IF(AND(M8>8501,M8<10001),90,IF(AND(M8>10001,M8<15001),110,IF(AND(M8>15001,L8<25001),130,IF(AND(M8>25001,M8<40001),150,IF(M8>40001,200,0)))))Note: M8 is the Gross Salary Cell.Hi Praveen,The PTax for...
Hi all,Can you please help me with the PT formula in one cell for all states? If I select the state and enter the gross, it should be calculated accordingly based on the state and gross.
Please help me with professional tax calculation for Andhra Pradesh state. The tax slabs for gross salary are as follows:- For gross salary between 15000 to 20000, the tax is 150.- For gross salary above 20000, the tax is 200.- For gross salary below 15000, the ...
=IF(J3="Female", CHOOSE(MATCH(W3,{0,25001},1), 0,200), CHOOSE(MATCH(W3,{0,7500,10000},1), 0,175,200))SELECT GENDER CELLW3 = SALARY WAGES
=IF(AND(AA$1="Feb PT", X2>10000), 300, IF(X2>10000, 200, IF(AND(X2>7500, Q2:Q31="Male"), 175, 0)))AA$1 = WRITE IN CELL FEB PTX2 = SALARY WAGESSELECT GENDER ROWTHIS IS MAHARASHTRA PT SLAB
Good Nilendra, but if we remove the quotation marks, we can sum it; otherwise, it is difficult to calculate the total sum.Ramesh P.
Dear All,I am mentioning below the Andhra Pradesh Professional Tax Slabs. Based on this, I need the Professional Tax calculation with an Excel formula. Please assist me.AP Professional Tax Slabs:- Income Between Rs. 0-5000: Professional Tax is Rs. 0- Income Betw...
**Professional Tax Calculation Using Excel Formula**To calculate the professional tax based on the Andhra Pradesh Professional Tax Slabs using Excel, follow these steps:1\. Open a new Excel worksheet.2\. In one column, list the income values for which you need t...
To calculate the Professional Tax slab in Gujarat using the IF function formula in Excel, you can use the following formula:=IF(C2>12000,"₹200",IF(C2>9000,"₹150",IF(C2>6000,"₹80",IF(C2>3000,"₹0","₹0"))))Where C2 represents the gross salary.The tax slab for calcu...
=IF(C2>=12000, "200", IF(C2>=9000, "150", IF(C2>=6000, "80", "0")))