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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D
(TOTAL b &c)[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]NO DEMAND[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]0[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]20[/TD]
[TD]20[/TD]
[TD]0[/TD]
[TD]20[/TD]
[TD]In Process[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]15[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]15[/TD]
[TD]0[/TD]
[TD]15[/TD]
[TD]Need to Order[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]20[/TD]
[TD]20[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]Healthy Stock[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]15[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]-15[/TD]
[TD]Pulled beyond[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]

---

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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.