If else statement help

[AceScottie]

Hello. Im having some problems wrighting this code into excel.
I have a range of data between 1 and 100,000. im looking for numbers above 20,000 to be in the Good section and below 20,00 to be in the poor section. Additionally i want all numbers below 5,000 to be discounted and the "Good" "Poor" box to be left blank.
I can wright this in code as below:

If 5000<B2>20000:
B3 = "Poor"
elif B2>20000:
B3 = "Good"
elif B2< 5000:
B3 = ""
else:
B3 = "Unknown"

problem is i cant find any elif functions in excel, it all seems to be "if true then / if flase then" whereas i just want if "true then"

[Tony Valko]

numbers above 20,000 to be in the Good section and below 20,00 to be in the poor section.

And what if the number IS 20,000?

This happens quite often.

[oeldere]

make a VLookup table

C D
0 blanc
5000 poor
20000 good

after that

b1=vlookup(a1,$c$1:$d$3,2,1)

[AlKey]

Try this
Enter formula in C2 and copy down

Please Login or Register  to view this content.

v	B	C
1
2	4000
3	20000	Good
4	30000	Good
5	4000
6	5899	Poor
7	19999	Poor

[AceScottie]

Thanks very much, using Lookup works perfectly for this information set

[Tony Valko]

If there are only 3 variables you can use an IF function...

=IF(B2>=20000,"Good",IF(B2>=5000,"Poor",""))