=IF(IF(AJ3<250000,0,IF(AJ3<350000,(AJ3-250000)*0.05-2500,IF(AJ3<500000,(AJ3-250000)*0.05,IF(AJ3>500000,(AJ3-500000)*0.2+12500,))))*1.03<=0,0,(IF(AJ3<250000,0,IF(AJ3<350000,(AJ3-250000)*0.05-2500,IF(AJ3<500000,(AJ3-250000)*0.05,IF(AJ3>500000,(AJ3-500000)*0.2+12500,))))*1.03))
FOR FY2017-18 SALARY UPTO 20% TAB SLAB
=IF(IF(AJ3<250000,0,IF(AJ3<350000,(AJ3-250000)*0.05-2500,IF(AJ3<500000,(AJ3-250000)*0.05,IF(AJ3>500000,(AJ3-500000)*0.2+12500,))))*1.03<=0,0,(IF(AJ3<250000,0,IF(AJ3<350000,(AJ3-250000)*0.05-2500,IF(AJ3<500000,(AJ3-250000)*0.05,IF(AJ3>500000,(AJ3-500000)*0.2+12500,))))*1.03))
FOR FY2017-18 SALARY UPTO 20% TAB SLAB
HOW TO ROUND OFF IN EXCEL
| Originally posted by : mohammad ansaruddin | ||
 |
HOW TO ROUND OFF IN EXCEL |
 |
1. Round a number to two decimal places.
Note: 1, 2, 3, and 4 get rounded down. 5, 6, 7, 8, and 9 get rounded up.
2. Round a number to one decimal place.
3. Round a number to the nearest integer.
4. Round a number to the nearest 10.
5. Round a number to the nearest 100.
The ROUNDUP function always rounds a number up (away from zero). For example, round a number up to one decimal place.
The ROUNDDOWN function always rounds a number down (toward zero). For example, round a number down to the nearest integer.
What is the Excel formula for calculation of interest under section 234A, 234B and 234C?
📢 Hello Taxpayers! 📢
Take advantage of our fully automatic tax calculation Excel sheet, now available for your convenience. Simply input your income and investments to compare the old and new tax regimes, helping you determine the most advantageous option. Don't forget to consider deductions, exemptions, and tax rates to tailor your decision to your unique financial situation.
Access/Download the Excel sheet here: (https://lnkd.in/gNgbyx3s)
Feel free to reach out if you have any questions or need assistance with the calculations.
📢 Hello Taxpayers! 📢
Take advantage of our fully automatic tax calculation Excel sheet, now available for your convenience. Simply input your income and investments to compare the old and new tax regimes, helping you determine the most advantageous option. Don't forget to consider deductions, exemptions, and tax rates to tailor your decision to your unique financial situation.
Access/Download the Excel sheet here: (https://lnkd.in/gNgbyx3s)
Feel free to reach out if you have any questions or need assistance with the calculations.
📢 Hello Taxpayers! 📢
Take advantage of our fully automatic tax calculation Excel sheet, now available for your convenience. Simply input your income and investments to compare the old and new tax regimes, helping you determine the most advantageous option. Don't forget to consider deductions, exemptions, and tax rates to tailor your decision to your unique financial situation.
Access/Download the Excel sheet here: (https://lnkd.in/gNgbyx3s)
Feel free to reach out if you have any questions or need assistance with the calculations.
please send fy 2025-26 excell formula for calculating slab
CAclubindia
