banner_ad

Excel formula

This query is : Resolved 
Avatar

Querist : Anonymous

Profile Image
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
Profile Image

Tony John

Profile Image

Tony John (Expert)
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.
Profile Image

Tony John

Profile Image

Tony John (Expert)
11 February 2017 Add applicable surcharge and cess also.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now


CCI Pro
Join CAclubindia WhatsApp Finance Community & stay updated with the latest TAX news, compliance alerts and important updates all in one place!


Similar Resolved Queries


loading


Unanswered Queries


banner

Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Follow us
add to google news



Answer Query



Quick Links



Browse by Category




Latest Job Openings

View all
Company
09 May 2026
Audit Manager

Kanna and Associates

Coimbatore

CA Inter

View Details
Company
08 May 2026
CHARTERED ACCOUNTANT

SHAH LADHA AND ASSOCIATE

Ahmedabad

CA

View Details
Company
ARTICLESHIP 15 May 2026
Audit Assistant / Article Trainee / Intern

SSGS and Associates

Chennai

CA Inter

View Details
Company
01 June 2026
Audit, Taxation & Compliance Executive

R P S K & Associates

Nashik

CA Inter

View Details
Company
12 May 2026
Accounts Executive

Nafa Group

Mumbai

B.Com

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
26 May 2026
Education Content Creator

Adyayam Education LLP

Bengaluru

CA Foundation

View Details