If statement question greater than or equal too

[zoomaj]

Hi guys,

i am trying to do an if statement and ran into some trouble! and need some help, its probably very simple but i cant figure it out,

basically i have a stock inventory with the amounts left displayed in percentages,

ie

100%
75%
50%
25%
0%



=IF(J11>=90,"STOCK OK",IF(J11=50,"HALF STOCK",IF(J11<=25,"25% STOCK LEFT",IF(J11<=0,"ORDER STOCK","ORDER STOCK"))))

im using the formula above, sometimes when i have 80% stock left it says order stock, any ideas why this is please? as im pretty sure< means less than?

cheers

 

[Scott Huish]

=LOOKUP(J11,{0,1,25,50,75,100},{"Out of Stock","25% Stock Left","??? Half stock left","??? Order stock","??? Stock OK","Full Stock"})

 

[T. Valko]

0 = out of stock
Greater than or equal to 1 and less than or equal to 24 = ??? 25% stock left
Greater than or equal to 25 and less than or equal to 49 = ??? half stock leftt
Greater than or equal to 50 and less than or equal to 74 = ??? order stock
Greater than or equal to 75 = ??? stock ok
100 = Full stock

I would create this 2 column table based on those definitions:

Book1
	L	M
11	0%	out of stock
12	10%	25% stock left
13	25%	half stock left
14	50%	order stock
15	75%	stock ok
16	100%	Full stock
Sheet1

Then...

J11 = some percentage like 31%

This formula entered in K11:

=LOOKUP(J11,L11:M16)

 

[zoomaj]

thank you both work

 

[T. Valko]

thank you both work

You're welcome. Thanks for the feedback!