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!

2 replies

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

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

CCM 2942 users have said thank you to us this month

Posts
3
Registration date
Sunday February 1, 2015
Status
Member
Last seen
February 6, 2015

ThanX for your help

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!