# Thread: Formula for a 3argument logic problem

1. ## 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  Reply With Quote

2. 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..  Reply With Quote

3. This will solve the first bit:

=IF(AND(A2<>A1,B2=B1+1),"F","-")

I do not understand the logic of the last three rows in your example.  Reply With Quote

formula, logic problem 