#### Excel formula for calculating slabs

Page no : 3

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

Replied 08 June 2018

HOW TO ROUND OFF IN EXCEL

Siddharth Goel (Chartered Accountant) (3026 Points)
Replied 20 June 2018

 Originally posted by : mohammad ansaruddin HOW TO ROUND OFF IN EXCEL

### ROUND

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.

### RoundUP

The ROUNDUP function always rounds a number up (away from zero). For example, round a number up to one decimal place.

### ROUNDDOWN

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

For Assessment Year 19-20 : =IF(CH3<250000,0,IF(CH3<500000,(CH3-250000)*0.05,IF(CH3<1000000,(CH3-500000)*0.2+12500,IF(CH3>1000000,(CH3-1000000)*0.3+112500,))))

Neethi V. Kannanth (.) (19015 Points)
Replied 20 January 2021

What is the Excel formula for calculation of interest under section 234A, 234B and 234C?

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.

Feel free to reach out if you have any questions or need assistance with the calculations.

Attached File : 4052941 20240510193641 computation income tax for the financial year 2024 25.xlsx downloaded: 29 times

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.

Feel free to reach out if you have any questions or need assistance with the calculations.

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.

Feel free to reach out if you have any questions or need assistance with the calculations.

view more »