I have to group some variables and assign the number in () into the following: <=5(1) 6-10(2) >10(3) Unknown(9) I can get the numbers in the right category except for Unknown (9). The variable for 9 is 99 in the spreadsheet. this is the formula that I used and it generates a 3 for 99 and that is not what I need. =IF(E2<=5,1,IF(E2<=10,2,IF(E2>=11,3,IF(E2=99,9))))
Comments
Leave a comment