IF statement returning false
Closed
danithompson99
Posts
1
Registration date
Tuesday January 9, 2018
Status
Member
Last seen
January 9, 2018
-
Jan 9, 2018 at 11:27 AM
Blocked Profile - Jan 9, 2018 at 04:59 PM
Blocked Profile - 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)))))))
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)))))))
Related:
- Why is my if statement returning false
- Fenix internet on bank statement - Guide
- Application for bank statement sbi - Guide
- If cell contains date then return value ✓ - Excel Forum
- Remove false from if statement ✓ - Office Software Forum
- Removing false in excel ✓ - Excel Forum
1 response
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
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
