Formula for a 3argument logic problem

Hello dear forum member, I am having problem with creating a 3 argument logic formula.
There are three columns 1,2,3. Formula that should put a letter F or - in column number 3 depending on logic in COLUMNS 1 and 2. Could anyone kind help me sort out this out?


1) 2) 3)
A 1 -
A 2 -
A 3 F
B 4 -
A 1 -
A 2 F
B 3 -
A 1 -
A 2 F
A 1 F
A 1 F

Hello and welcome to the forum.

What is the logic that would make the 3rd column F?
What is the logic that would make the 3rd column -?

There are 3 logic problems:

1) 2) 3)
A 1 -
A 2 -
A 3 F (F HERE BECAUSE NEXT ROW POSITION IN COLUMN 2 IS NEXT NUMBER AND ITS B IN COLUMN 1
B 4 -
A 1 -
A 2 F (F HERE BECAUSE NEXT ROW POSITION IN COLUMN 2 IS NEXT NUMBER AND ITS B IN COLUMN 1)
B 3 -
A 1 -
A 2 F (F HERE BECAUSE NEXT ROW POSITION IN COLUMN 2 IS AGAIN NUMBER 1)
A 1 F (F HERE BECAUSE NEXT ROW POSITION IN COLUMN 2 IS AGAIN NUMBER 1)
A 1 F and its a continuation..

Were we supposed to figure that out based on what you shared in post #1?

Sorry, but I do not understand the logic here.

Please try
D1 =IF(OR(AND(B1+1=B2,A2="B"),AND(A2=A1,B2=1),B2=""),"F","-")

Bo_RY - result is:

A 1 -
A 2 -
A 3 -
B 4 F
A 1 -
A 2 -
B 3 F
A 1 -
A 2 -
A 1 F
A 1 F

It doesn't match my needs, however its close - could you inspect it?

Hi Calios,

It works fine on my sheet.

BO_RY - its works great! However I missed one thing. Could you add one more thing - if its B after B after B after B it gives -? It seems to give F if its B after B after B.

Thank you!

Not sure what you mean, but try =IF(OR(AND(B1+1=B2,A2="B",A1="A"),AND(A1:A2="A",B2=1),B2=""),"F","-")

Calios,
What is the logic and result for "ZAMKNIĘTY"?

Bo_Ry - logic is exactly the same as for "NIEZREALIZOWANY"

Then you can replace "NIEZREALIZOWANY" with "ZAMKNIĘTY" and add inside Or( )