Previous Topic Next Topic

Removing false in excel

[Solved/Closed]
Report
Posts
3
Registration date
Sunday February 1, 2015
Status
Member
Last seen
February 6, 2015
 -
Posts
3
Registration date
Sunday February 1, 2015
Status
Member
Last seen
February 6, 2015
 -
=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!
Related:

2 replies

Answer 1 / 2
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
 24
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,""))))
1
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Answer 2 / 2
Posts
3
Registration date
Sunday February 1, 2015
Status
Member
Last seen
February 6, 2015
ThanX for your help
Ask a question