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
- Query Regarding on TDS section 194H and 194J
- NR GST NUMBER
- Fixed Deposit Claim Relinquishment by the Nominee
- Applicability
- ITR 6 Schedule CFL and UD Issues
- Legal heir raised refund , but refund issued to the closed account of deceased.
- Gst Sales of FY 2023-24
- GSTR-3B - Do I file nil when there is no sale but I've bought raw materials
- GST Form ADT-02
- TDS RATE ON RENT PAID TO NRI
- Form - 26BQ
- Companies Act FA Excel
- PAYMENT TO OPEN AI AND ENVATO ELEMENT
- Issue of gst e invoice
- Interchangeable words in accounts
- Adjusted profit/Loss in the case of LLP and Pvt. Ltd.company
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
Trending Online Classes
-
Excel Mastery Program
CA Rishabh Pugalia
CAclubindia
