Removing false in excel
Solved/Closed
umer007
Posts
3
Registration date
Sunday February 1, 2015
Status
Member
Last seen
February 6, 2015
-
Feb 1, 2015 at 06:23 AM
umer007 Posts 3 Registration date Sunday February 1, 2015 Status Member Last seen February 6, 2015 - Feb 2, 2015 at 05:42 AM
umer007 Posts 3 Registration date Sunday February 1, 2015 Status Member Last seen February 6, 2015 - Feb 2, 2015 at 05:42 AM
=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!
What,s wrong in this formula Please Help!
Related:
- Remove false from if statement
- Fenix internet on bank statement - Guide
- How to remove story from close friends - Instagram Forum
- Removing " false" value in "IF" ✓ - Office Software Forum
- How to remove call barring in keypad mobile - Word Forum
- How to remove tiktok shop from my profile ✓ - TikTok Forum
2 responses
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Feb 1, 2015 at 07:56 PM
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,""))))