Menu
Ask a question Report

Removing false in excel [Solved/Closed]

umer007 3 Posts Sunday February 1, 2015Registration date February 6, 2015 Last seen - Feb 1, 2015 at 06:23 AM - Latest reply: umer007 3 Posts Sunday February 1, 2015Registration date February 6, 2015 Last seen
- Feb 2, 2015 at 05:42 AM
Excel Ask a question Report
=IF(D5>=150000,D5*21/100,IF(D5>=100000,D5*15/100,IF(D5>=70000,D5*21/100,IF(D5>=50000,D5*7/1000))))


What,s wrong in this formula Please Help!
See more 

2 replies

Report Respond to RayH
RayH 122 Posts Tuesday August 31, 2010Registration dateContributorStatus June 20, 2016 Last seen - Feb 1, 2015 at 07:56 PM
0
Thank you
You are missing what happens if the evaluations are not met.

The , "" is required to do that.

=IF(D5>=150000,D5*21/100,IF(D5>=100000,D5*15/100,IF(D5>=70000,D5*21/100,IF(D5>=50000,D5*7/1000,""))))
Report Respond to umer007
umer007 3 Posts Sunday February 1, 2015Registration date February 6, 2015 Last seen - Feb 2, 2015 at 05:42 AM
0
Thank you
ThanX for your help
Ask a question
Featured