Forum Discussion
Auto select a band
HI I am hoping someone can help me. I have series of bands; 1. <5.9 2. 6-8.9 3. 9-11.9 4. 12-14.9 etc etc I'd like to be able to insert a number (e.g 7) into a cell and for the adjacent c...
Another variant, if put series in the range as
the formula could be
=LOOKUP(A1,$E$1:$E$4,$F$1:$F$4)
or, for this concrete one,
=INT(A1/3)+(A1<3)