Results 1 to 3 of 3

Thread: Formula for a 3argument logic problem

  1. #1
    Neophyte Calios's Avatar
    Join Date
    Sep 2018
    Posts
    2
    Articles
    0
    Excel Version
    2017

    Question 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. #2
    Neophyte Calios's Avatar
    Join Date
    Sep 2018
    Posts
    2
    Articles
    0
    Excel Version
    2017
    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. #3
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,400
    Articles
    0
    Excel Version
    Office 365 Subscription
    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.
    Ali
    Enthusiastic self-taught user of MS Excel!

Tags for this Thread

Posting Permissions

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