ramachandran
(MGR)
(23 Points)
Replied 31 March 2018
=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
Siddharth Goel
(Chartered Accountant)
(3026 Points)
Replied 20 June 2018
| 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.
lokesh vamsi
(2 Points)
Replied 08 May 2019
Neethi V. Kannanth
(.)
(19015 Points)
Replied 20 January 2021
What is the Excel formula for calculation of interest under section 234A, 234B and 234C?
Vishvajeet Yadav
(6 Points)
Replied 10 May 2024
📢 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.
Vishvajeet Yadav
(6 Points)
Replied 10 May 2024
📢 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.
Vishvajeet Yadav
(6 Points)
Replied 10 May 2024
📢 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.
CAclubindia
