Removing false in excel
Solved/Closed
umer007
umer007
- Posts
- 3
- Registration date
- Sunday February 1, 2015
- Status
- Member
- Last seen
- February 6, 2015
umer007
- Posts
- 3
- Registration date
- Sunday February 1, 2015
- Status
- Member
- Last seen
- February 6, 2015
Related:
- How to remove false in excel
- How to get rid of false in excel - Best answers
- Remove false from excel - Best answers
- Removing " false" value in "IF" ✓ - Forum - Office Software
- Remove false from excel ✓ - Forum - Office Software
- Removing False Value ✓ - Forum - Excel
- Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Forum - Excel
- How to remove false error in excel - Forum - Excel
2 replies
RayH
Feb 1, 2015 at 07:56 PM
- Posts
- 122
- Registration date
- Tuesday August 31, 2010
- Status
- Contributor
- Last seen
- June 20, 2016
Feb 1, 2015 at 07:56 PM
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,""))))
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,""))))
umer007
Feb 2, 2015 at 05:42 AM
- Posts
- 3
- Registration date
- Sunday February 1, 2015
- Status
- Member
- Last seen
- February 6, 2015
Feb 2, 2015 at 05:42 AM
ThanX for your help