Hello.

I am using randbetween to generate a number that is meant to produce a text output.

randbetween produces the number, I reference it in the if string, and no matter the value in the randbetween cell, I come back with the output for the lowest numeriacal value.

the string is here:

- Code: Select all Expand viewCollapse view
`=IF(C2>96,"AM",IF(97>C2>80,"INC",IF(81>C2>60,"REM",IF(61>C2>40,"EX",IF(41>C2>20,"GD",IF(21>C2>10,"TYP",IF(11>C2>5,"PR",IF(6>C2>1,"FE","WTF"))))))))`

Without fail, I get "WTF". What am i doing wrong?

EDIT: SOLVED