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
- Tax Audit Applicability – Newly Formed Partnership Firm with Profit Below 6%/8%
- TDS CREDIT MISMATCHING
- Buy back of shares u/s69
- Unregistered suppliers utility
- Difference between Date of Payment and Date of Deduction?
- EXPORT COMMERCIAL INVOICE HSN CODE
- Bank details not Visible on Traces Portal
- Taxability of Partnership firm for FY 2025-26
- GST Rate for Catering Services
- URGENT-Eligible leaves being shown as 24 days for 3 years Articleship instead of 156 days in 108
- ITDS U/S.194T of Firm
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
- LLP audit under companies act
- Experienced CA recommendation from Kolkata for FNO return filing
- Interest Reporting in Form 168
- Sales of goods of amount Rs77 lakhs to a party
- Tax Demand of ₹4,650 for AY 2026-27
- Concept of Vendor and customner reconciliation
- Mistake in e-invoice identified after 24 hours
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
