I have some data I want to sort between different values, I want to have values -5.5 between -5.0 t then to display -4, and lets say 1.5 to 2.0 to display 3, I have 23 different ranges I want to work with, I have tried this where I am linking the data and the cell ref to the display numbers, I just get a bunch of ones and zeros display when I write this.
=IF(AND(D22<$T$49),$U$49,IF(AND(D22>$T$49, D22<=$T$48),$U$48, IF(AND(D22>$T$48,D22<=$T$47),U$47, IF(AND(D22>$T$47,D22<=$T$46),$U$46, IF(AND(D22>$T$46,D22<=$T$45),$U$45,IF(AND(D22>$T$45,D22<=$T$44),$U$44,IF(AND(D22>$T$44,D22<=$T$43),$U$43,IF(AND(D22>$T$43,D22<=$T$42),$U$42,IF(AND(D22>$T$42,D22<=$T$41),$U$41,IF(AND(D22>$T$41,D22<=$T$40),$U$40,IF(AND(D22>$T$40,D22<=$T$39),$U$39,IF(AND(D22>$T$39,D22<=$T$38),$U$38,IF(AND(D22>$T$38,D22<=$T$37),$U$37,IF(AND(D22>$T$37,D22<=$T$36),$U$36,IF(AND(D22>$T$36,D22<=$T$35),$U$35,IF(AND(D22>$T$35,D22<=$T$34),$U$34,IF(AND(D22>$T$34,D22<=$T$33),$U$33,IF(AND(D22>$T$33,D22<=$T$32),$U$32,IF(AND(D22>$T$32,D22<=$T$31),$U$31,IF(AND(D22>$T$31,D22<=$T$30),$U$30,IF(AND(D22>$T$30,D22<=$T$29),$U$29,IF(AND(D22>$T$29,D22<=$T$28),$U$28,IF(AND(D22>$T$28,D22<=T47),$U$28,IF(AND(D22>$T$27),$U$27,””))))))))))))))))))))))))
Bookmarks