IF statement returning false

danithompson99 1 Posts Tuesday January 9, 2018Registration date January 9, 2018 Last seen - Jan 9, 2018 at 11:27 AM - Latest reply: ac3mark 8645 Posts Monday June 3, 2013Registration dateModeratorStatus January 22, 2018 Last seen
- Jan 9, 2018 at 04:59 PM
Hello,

The following IF statement is returning false. Please let me know how to get it to return a value. Thank you

=IF(D6<50000,((D6/2000)*10.3)*1.025, IF(49999<D6<100000,((D6/2000)*16.5)*1.025, IF(99999<D6<200000,((D6/2000)*18.55)*1.025, IF(199999<D6<220000,((D6/2000)*22.65)*1.025, IF(219999<D6<240000, ((D6/2000)*24.7)*1.025, IF(239999<D6<260000,((D6/2000)*26.8)*1.025, IF(259999<D6<280000,((D6/2000)*27.8)*1.025)))))))
See more 

1 reply

Reply to this topic
ac3mark 8645 Posts Monday June 3, 2013Registration dateModeratorStatus January 22, 2018 Last seen - Updated by ac3mark on 9/01/18 at 04:59 PM
0
Helpful
You have no last false statment. That is why is returns FALSE. NONE of the above is true!

Take a look here:
IF(259999<D6<280000,((D6/2000)*27.8)*1.025)))))))

You have no False return--------------------------------------^,false)))))

What do you want displayed?

It's kind of fun to do the impossible! -Walter Elias Disney
Respond to ac3mark