Hi, Im trying to come up with a scoring system where:
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," "))))))...