Okay here is another one!


Posted by NIcki on October 05, 2001 2:34 PM

Thanks for the help on that one but here is another problem.... I need a formula that states if the number is between 1 and 6 enter "1" if the number is between 7 and 12 enter "2" if the number is between 13 and 18 enter "4" and if the number is above 18 enter "5"... Now the problem is that I need this to be all one formula that I can copy down. I have a bunch of numbers that I need figured this way. Thanks in advance!



Posted by Aladin Akyurek on October 05, 2001 2:49 PM

Nicki,

Try:

=IF(A1,VLOOKUP(A1,{0,1;7,2;13,3;19,4;24,5},2),"")

Adjust {0,1;7,2;13,3;19,4;24,5} if I misconstructed your assignment values.

Aladin

==========