Status Changes

[TheRins3r]

I need a number of cellsto change status, but im struggling.

Key number is the system qty (K)., ive added comments in some cells.

Bin	Product Code	1st Count	1st Count Status	2nd Count	2nd Count status	Final Count	System QTY	Difference	What Counts where used to confirm the difference
RF 1 A	X	9	2nd count Required	8	Final Count Required	8	10
RF 1 B	Y	1	Correct Match		Final Count Required		1
RF 1 C	Z		Correct Match		No Final Count Required		0
RF 1 D

1st Count status Formula: =IF(E2=J2,"Correct Match","2nd count Required")

2nd Count status formula: =IF(E2=G2,"No Final Count Required","Final Count Required"

If system is 0, id like 1st count status to say not required, as well as 2nd count.

if 1st count is correct match, id like 2nd count status to be blank or say not required etc.

Also, the last column, is there a way i can state that counts 2 & final count were the counts used to confirm differences etc

 

[GlennUK]

Just nest your IFs .. like for 1st Count stats formula: =IF(K2=0,"Not Required",IF(E2=J2,"Correct Match","2nd count Required"))
2nd Count status formula: =IF(OR(F2="Correct Match",K2=0),"Not Required",,IF(E2=G2,"No Final Count Required","Final Count Required"))

I don't understand what you mean about the logic of the last column ... can you explain further?