# Thread: Formula for a 3argument logic problem

1. ## Formula for a 3argument logic problem

Register for a FREE account, and/
or Log in to avoid these ads!

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

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

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.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•