If condition required

[Faraz5023]

I have a sheet and in this sheet column U have QTY 1 to 100 I need If the condition is less than 5 to give me a text "Good" if the QTY is between 5 to 10 give me a text "poor", and greater than 10 give me text "bad". currently, I use the Below-mentioned formula but given the error between conditions.

=IF(U2<=6,"Good",IF(U2>=6<10,"Poor",IF(U2>10,"Bad","-")))

 

[DeepuSultan]

Hi,

Try this

=IF(U2<5,"Good",IF(AND(U2>=5,U2<=10),"Poor","Bad"))

 

[etaf]

=IF(U2<=6,"Good",IF(AND(U2>6,U2<10),"Poor",IF(U2>10,"Bad","-")))
BUT
What do you want 10 to be ???
as you dont have an =10

Also a blank cell will give good
so maybe
=IF(U2="", "", IF(U2<=6,"Good",IF(AND(U2>6,U2<10),"Poor","Bad")))
As - will never be seen

Book7
	U	V	W
1
2	1	Good	Good
3	6	Good	Poor
4	8	Poor	Bad
5	10	-	Bad
6	12	Bad
7		Good
8		Good
9		Good
Sheet1

Cell Formulas
Range	Formula
V2:V9	V2	=IF(U2<=6,"Good",IF(AND(U2>6,U2<10),"Poor",IF(U2>10,"Bad","-")))
W2:W9	W2	=IF(U3="","",IF(U3<=6,"Good",IF(AND(U3>6,U3<10),"Poor","Bad")))

 

[Faraz5023]

=IF(U2<=6,"Good",IF(AND(U2>6,U2<10),"Poor",IF(U2>10,"Bad","-")))
BUT
What do you want 10 to be ???
as you dont have an =10

Also a blank cell will give good
so maybe
=IF(U2="", "", IF(U2<=6,"Good",IF(AND(U2>6,U2<10),"Poor","Bad")))
As - will never be seen

Book7
	U	V	W
1
2	1	Good	Good
3	6	Good	Poor
4	8	Poor	Bad
5	10	-	Bad
6	12	Bad
7		Good
8		Good
9		Good
Sheet1

Cell Formulas
Range	Formula
V2:V9	V2	=IF(U2<=6,"Good",IF(AND(U2>6,U2<10),"Poor",IF(U2>10,"Bad","-")))
W2:W9	W2	=IF(U3="","",IF(U3<=6,"Good",IF(AND(U3>6,U3<10),"Poor","Bad")))

Superb Issue resolved thanks a lot.

 

[etaf]

you are welcome, I notice my formula is in row 3 - BUT referencing row 2
so just for completeness

Book7
	U	V	W
1
2	1	Good	Good
3	6	Good	Good
4	8	Poor	Poor
5	10	-	Bad
6	12	Bad	Bad
7		Good
8		Good
9		Good
Sheet1

Cell Formulas
Range	Formula
V2:V9	V2	=IF(U2<=6,"Good",IF(AND(U2>6,U2<10),"Poor",IF(U2>10,"Bad","-")))
W2:W9	W2	=IF(U2="","",IF(U2<=6,"Good",IF(AND(U2>6,U2<10),"Poor","Bad")))

 

[DeepuSultan]

less than 5 to give me a text "Good" if the QTY is between 5 to 10 give me a text "poor", and greater than 10 give me text "bad"

You asked for this right? hence I gave you what you wanted exactly i.e. =IF(U2<5,"Good",IF(AND(U2>=5,U2<=10),"Poor","Bad"))

or you can use this as well =IF(U2="","",IF(U2<5,"Good",IF(AND(U2>=5,U2<=10),"Poor","Bad")))

Book1
	U	V
2	1	Good
3	6	Poor
4	5	Poor
5	8	Poor
6	6	Poor
7	4	Good
8	2	Good
9	7	Poor
10	9	Poor
11	3	Good
12	4	Good
13	10	Poor
14	11	Bad
15
Sheet1

Cell Formulas
Range	Formula
V2:V15	V2	=IF(U2="","",IF(U2<5,"Good",IF(AND(U2>=5,U2<=10),"Poor","Bad")))