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

 

[Legacy 185660]

I dont really get what you are trying to do.
What should it say if you are between 89 - 51 and from 49-26?

 

[kpark91]

It's because you're not covering the whole range of values.

In your third If statement, there's
J11 <= 25 condition.

And in your first If statement, there's
J11 >= 90

while in your second If statement, there's only
J11 = 50

This means that any values you input between 90 and 25 (exclusive) except for 50 , it will print "ORDER STOCK" because it is the last FALSE statement.

 

[zoomaj]

Hi guys thanks for your help so far,
your right iv not covered all the values any ideas on what i need to input to cover all the values please?

cheers

Anj

 

[Legacy 185660]

=IF(A4<25,"ORDER STOCK",IF(A4=25,"25% STOCK",IF(A4<=50,"HALF(ish) STOCK","STOCK OK")))

 

[zoomaj]

thank you salim it works, i can get moving forward now as i can see where i was going wrong, i wasnt covering all the values,

thank you

 

[T. Valko]

Hi guys thanks for your help so far,
your right iv not covered all the values any ideas on what i need to input to cover all the values please?

cheers

Anj

You need to define what result you want based on an interval of values.

If you have 0 then obviously you have no stock.

So, you might define the intervals something like this...

0 = out of stock
Greater than or equal to 1 and less than or equal to 24 = ???
Greater than or equal to 25 and less than or equal to 49 = ???
Greater than or equal to 50 and less than or equal to 74 = ???
Greater than or equal to 75 = ???

Once you get the intervals CLEARLY defined we'll be able to make formula suggestions.

 

[zoomaj]

Hi Valko

75 to 99 = stock ok
100 - full stock

your on the right lines,

salim helped but i do need a little more definition in my formula, please can you assist further?

kind regards

anj

 

[zoomaj]

24= less than 25% stock
49= less than half stock left
74= less than 75%left

 

[zoomaj]

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