Way:If Statement

[athard]

I have a spreadsheet where the area column has numbers between 1 and 22.

What I want to do is to add a column to the right of that and based on the number, it puts a value. For example, if it is numbers 1 through 7, it will say South. 8-9, it will say West, etc etc.

I stared to do this with an If statement, but given that there are 22 numbers, it was an incredibly long if statement. Is there a shorter way to do this? I found a way to do is using the Vlookup function, but i need to send the solution to somebody to use for their spreadsheets, and teaching them the Vlookup function is near impossible.

Is there an easy way to do this? here are the values:


1 South
2 South
3 South
4 South
5 South
6 South
7 South
8 West
9 West
10 East
11 East
12 East
13 East
14 East
15 East
16 West
17 West
18 North
19 North
20 North
21 North
22 North


Thank you in advance.

[bentleybob]

=IF(A1<8,"South",IF(A1<10, "West",IF(A1<16,"East",IF(A1<18,"West","North"))))

[NBVC]

If you want one that you probably won't get questioned on, then try:

=IF(A2="","",IF(A2>=20,"North",IF(A2>=16,"West",IF(A2>=10,"East",IF(A2>=8,"West","South"))

a simple nested if.

or you could also use:

=LOOKUP(A2,{0,1,8,10,16,18},{"","South","West","East","West","North"})