Thanks:  0
Likes:  0

# Thread: If Statment VERY Simple

1. 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

2. Try:

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

Incidentally, how does this sequence make sense?

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-05-03 14:53 ]

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

4. 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, NateO

[ This Message was edited by: NateO on 2002-05-03 15:04 ]

5. =VLOOKUP(A1,{0,1;11,2;26,3;...},2)

[ This Message was edited by: Mark W. on 2002-05-03 14:59 ]

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

7. Neat trick Mark. Kudos.

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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•