If Statment VERY Simple

[HotNumbers2001]

Need the following... Comun A has the following numbers 1 through 100. Need to have column be return the following numbers.
IF colum A the number is between 0 through 10 then return 1, if the number is between 11 - 25, then return 2, etc.....

avo

 

[NateO]

Try:

=IF(A1<11,1,IF(A1<26,2,"etc…"))

Incidentally, how does this sequence make sense?

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue">O</font></font></font>

This message was edited by NateO on 2002-05-03 14:53

 

[Ricky Morris]

=if(and(a1>0,a1<25),1,if(and(a1>25,a1<50),2,if...

 

[NateO]

Ricky, that doesn't work for case 2, but conceptually sound. I'm guessing your sequence grows by 5 every increment 10, 15, 20, 25 (I feel like I'm taking the SAT here). Try this:

=IF(A1<11,1,IF(A1<26,2,IF(A1<56,3,IF(A1<76,4,5))))

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue">O</font></font></font>

This message was edited by NateO on 2002-05-03 15:04

 

[Mark W.]

=VLOOKUP(A1,{0,1;11,2;26,3;...},2)
This message was edited by Mark W. on 2002-05-03 14:59

 

[HotNumbers2001]

Thank you all for your great help..... You guys are really amazing....

 

[NateO]

Neat trick Mark. Kudos.

 

[HotNumbers2001]

thank you all for the help.... each of them works in a different way, but they all work.