Easy Office
LCI Learning

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


mohammad ansaruddin (student) (28 Points)
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.

Round to Two Decimal Places in Excel

 

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.

Round to One Decimal Place

3. Round a number to the nearest integer.

Round to the Nearest Integer

4. Round a number to the nearest 10.

Round to the Nearest 10

5. Round a number to the nearest 100.

Round 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.

Round Up to One Decimal Place, Positive Number

Round Up to One Decimal Place, Negative Number

ROUNDDOWN

The ROUNDDOWN function always rounds a number down (toward zero). For example, round a number down to the nearest integer.

Round Down to the Nearest Integer, Positive Number

Round Down to the Nearest Integer, Negative Number


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?



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.


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

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.



Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Join CCI Pro


Subscribe to the latest topics :

Search Forum: