Formula for a 3argument logic problem

C

Calios

New member
Joined
Sep 21, 2018
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2017
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?
confused.gif
confused.gif



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
 
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..
 
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.
 
You must log in or register to reply here.
Back
Top