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!