IF and Statement?

[WormJacob]

Hi,

Please help.. Need a formula. I couldnt make the string?

i NEED FORMULA ON "H" that will output the following scenario? many thanks

	A	B	C	D (TOTAL b &c)	E	F	G	H
1	0	0	0	0	0	0	0	NO DEMAND
2	0	10	10	20	20	0	20	In Process
3	15	0	0	0	15	0	15	Need to Order
4	0	0	20	20	0	0	0	Healthy Stock
5	15	0	0	0	0	0	-15	Pulled beyond

<tbody>
</tbody>

<tbody>
</tbody>

 

[WormJacob]

I will test it.. Thank you

 

[WormJacob]

Excel 2016 (Windows) 32 bit
	A	B	C	D	E	F	G	H	I	J
1		A	B	C	D	E	F	G	H
2	1	To pull	Prod	Finish	Total of Prod & Finish	Order	Shipping	Balance	Status	Status Notes Explanation
3	2	0	0	1	0	1	0	1	NtO	I changed Finish & Order Result : supposed to be HS?
4	3	0	10	10	20	0	25	-25	HS	I changed Order & Shipping & Order Result : supposed to be a HS since I have 10pcs in Finish
5	4	15	0	0	0	15	0	15	NtO	ok
6	5	0	0	20	20	0	0	0	HS	ok
7	6	15	0	0	0	0	15	-15	PB
8	7	0	5	10	15	20	0	20	NtO
9	8	0	15	10	25	20	20	0	IP
Sheet1

 

[WormJacob]

Excel 2016 (Windows) 32 bit
	A	B	C	D	E	F	G	H	I
1	To pull	Prod	Finish	Total of Prod & Finish	Order	Shipping	Balance	Status	Status Notes Explanation
2	0	0	1	0	1	0	1	NtO	I changed Finish & Order Result : supposed to be HS?
3	0	10	10	20	0	25	-25	HS	I changed Order & Shipping & Order Result : supposed to be a HS since I have 10pcs in Finish
4	15	0	0	0	15	0	15	NtO	ok
5	0	0	20	20	0	0	0	HS	ok
6	15	0	0	0	0	15	-15	PB
7	0	5	10	15	20	0	20	NtO
8	0	15	10	25	20	20	0	IP
Sheet1

 

[Peter_SSs]

I'm not following
1. I assume post 12 was a mistake?

2. Row 2 in post 13. If Prod is 0 and Finish is 1, how can Total of Prod & Finish be 0? To me, the Total should be 1 and if so that row would be exactly the same scenario as the second example in your original post which was "In Process"

3. Row 3 in post 13. You say that it is supposed to be HS, but it already is HS.

 

[WormJacob]

Hi
My response to your question..( my connection was bad and kept hanging)

I'm not following
1. I assume post 12 was a mistake?
Answer :I uploaded and cannot take them out.(sorry) mistake

2. Row 2 in post 13. If Prod is 0 and Finish is 1, how can Total of Prod & Finish be 0? To me, the Total should be 1 and if so that row would be exactly the same scenario as the second example in your original post which was "In Process"
​ Answer : Correct Total of Prod & Finish should BE 1

3. Row 3 in post 13. You say that it is supposed to be HS, but it already is HS.
Answer : Ignore them please..

thank you

 

[Peter_SSs]

2. Row 2 in post 13. If Prod is 0 and Finish is 1, how can Total of Prod & Finish be 0? To me, the Total should be 1 and if so that row would be exactly the same scenario as the second example in your original post which was "In Process"
Answer : Correct Total of Prod & Finish should BE 1

So the current formula returning "In Process" is correct?

3. Row 3 in post 13. You say that it is supposed to be HS, but it already is HS:
Answer : Ignore them please..

Ignore what? Your previous comment about this row?
So the current formula returning "Healthy Stock" is correct?

 

[WormJacob]

Thank you thank you for the tremendous help..

 

[Peter_SSs]

Sounds like it all came good in the end. You're welcome.