Excel formula
This query is : Resolved
Querist : Anonymous
Querist :
Anonymous
(Querist)
07 February 2017
I have used below formula for calculating income tax F.Y. 2017-18. But, this formula not work properly any body can help me to modified this formula.
=SUMPRODUCT(--(BN4>{250000;500000;1000000}),(BN4-{250000;500000;1000000}),{0.05;0.1;0.1})
sent me : HRAHEVAR@YAHOO.CO.IN
=SUMPRODUCT(--(BN4>{250000;500000;1000000}),(BN4-{250000;500000;1000000}),{0.05;0.1;0.1})
sent me : HRAHEVAR@YAHOO.CO.IN
11 February 2017
Sir can I suggest you another formula for FY 2016-17 :
[Total Income in Cell D19]
=IF(D19>1000000,(D19-1000000)*0.3+125000,IF(D19>500000,(D19-500000)*0.2+25000,IF(D19>250000,(D19-250000)*0.1,0)))
Reduce rebate u/s 87A from this if eligible.
[Total Income in Cell D19]
=IF(D19>1000000,(D19-1000000)*0.3+125000,IF(D19>500000,(D19-500000)*0.2+25000,IF(D19>250000,(D19-250000)*0.1,0)))
Reduce rebate u/s 87A from this if eligible.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- About TDS & Income Tax
- Section 194JA & JB Income which ITR Form to use
- Pass word to open justification report for Q1 for FY 2026-27
- PPF interest-As Exempt Income disclosure
- Under construction property in ITR
- Scrutiny and reopening of past returns
- Booth for sales promotion
- Upload Level ValidationITR3Category of Defect B/D
- Building tax payment deduction in rental Income
- F & O PROFIT REPORTING FOR AY 2026-27
- Difference in GSTR3B system generated which is correct and actual Payment it asks
- Indian IT Portal issue in computing tax as per UK-India DTAA
- Capital Gains on sale of residential flat
- PF Taxable Income
- Clarification on Tax Audit Applicability and Reporting of F&O Transactions in ITR-3
- Interest credited in FY2025-2026 & TDS therein by EPFO does not reflect in AIS or Form 26AS
- 44ad eligble money lending interest
- Taxation in the hands of Landowner under JDA
- Delisted shares sold in off market/ Rebate u/s87A
- In Exports Sales HSN details where to fill
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
