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]

 

[Scott Huish]

Can you please explain the criteria for each result?

 

[WormJacob]

[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A-
To pull[/TD]
[TD]B-Production[/TD]
[TD]C-
Finish[/TD]
[TD]D
(TOTAL b &c)[/TD]
[TD]E-Order[/TD]
[TD]F-Shimpment[/TD]
[TD]G-
Order_Balance[/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]

Hi,
Thanks for quick replied

I just added a label on each column. i want to have a result on column H where my scenario. The main is column "E" order.

Line 1 "E" ZERO order : Result no demand
Line 2: "E" order 20 and C is not enough to cover but have 10 in "B" prod. : Result in process
Line 3 : "E" order for 15 but zero on "C" : Result Need to order
Line 4 : "E" zero order but have plenty in Finish Good : Result Healthy stock
Line 5 : "E" zero in order (15 "F" suppose to be ..I forgot) and Balance "G" -15 ; Result Pulled beyond

Thank you in advance


[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

To help clarify, what would the results be for rows 7 and 8 below and why?

Book1
	A	B	C	D	E	F	G	H
1	To pull	Production	Finish	Total	Order	Ship	balance
2	0	0	0	0	0	0	0	NO DEMAND
3	0	10	10	20	20	0	20	In Process
4	15	0	0	0	15	0	15	Need to Order
5	0	0	20	20	0	0	0	Healthy Stock
6	15	0	0	0	0	15	-15	Pulled beyond
7		5	10		20
8		15	10		20
Stock

 

[WormJacob]

Hi

Thank you for clarifying.. Row7 & Row 8 was an error .. it was NOT supposed to be there.I probably mistakenly added.

thank you in Advanced

 

[Peter_SSs]

I think you missed my point. What would go in column H if the data was as I showed in my rows 7 and 8?

 

[WormJacob]

Hi,

Sorry .. Yeah I did missed your point..
7 & 8 result will be both "IN PROCESS"

Why?
Both Column "E" orders are for 20 and i don't have enough in Column "C" finish product.

thank you

 

[Peter_SSs]

7 & 8 result will be both "IN PROCESS"

Why?
Both Column "E" orders are for 20 and i don't have enough in Column "C" finish product.

I'm struggling a bit with row 7 being "In progress". In that row, as I understand it, Total would be 15, which isn't enough for the Order of 20 so why isn't the result "Need to order" like row 4 which also fits the blue description.?

 

[WormJacob]

Ohh My (That is my Baaddd)))

ROW 7 will be : Need to Order since only 15 total i have while the order is 20
Row 8 In Process

Thank you ..

 

[Peter_SSs]

Thanks for clearing that up. Try this formula, copied down. You will just have to fill out the text parts as I have just used abbreviations

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	To pull	Production	Finish	Total	Order	Ship	Balance	Result	Expected
2	0	0	0	0	0	0	0	ND	NO DEMAND
3	0	10	10	20	20	0	20	IP	In Process
4	15	0	0	0	15	0	15	NtO	Need to Order
5	0	0	20	20	0	0	0	HS	Healthy Stock
6	15	0	0	0	0	15	-15	PB	Pulled beyond
7		5	10	15	20			NtO	Need to Order
8		15	10	25	20			IP	In Process
Stock