Hi, Im trying to come up with a scoring system where:
Im using this formula: =IF(C27<9,25,IF(C27<19,75,IF(C27>25<34,100,IF(C27<44,50,IF(C27<50,25,IF(C27>51,0," "))))))
But its giving me the wrong answer because for a level of debt of 25% the points should be 100, yet is giving me 25.
Help! Anyone!!!!
Debt Level floor | Debt level ceiling | Points |
0% | 9% | 25 |
10% | 19% | 75 |
20% | 34% | 100 |
35% | 44% | 50 |
45% | 50% | 25 |
50% | 51% | 0 |
Im using this formula: =IF(C27<9,25,IF(C27<19,75,IF(C27>25<34,100,IF(C27<44,50,IF(C27<50,25,IF(C27>51,0," "))))))
But its giving me the wrong answer because for a level of debt of 25% the points should be 100, yet is giving me 25.
Help! Anyone!!!!