+ Reply to Thread
Results 1 to 6 of 6

Logic Tree to IF/AND Formula Conversion

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    08-25-2013
    Location
    Virginia, USA
    MS-Off Ver
    Microsoft 365 Version 2409 64-bit
    Posts
    243

    Logic Tree to IF/AND Formula Conversion

    Does anyone know how to convert this logic tree into a formula?

    Check if D2="1" & E2="L"
    IF D2="1" & E2="L" check if D3="2". IF D3 <> 2 THEN: N2=""
    -----------------------------------IF D3 = 2 check if J3 >-191
    --------------------------------------------------------------IF J3<-191 check if D4=3.
    ---------------------------------------------------------------------------------------IF D4<>3 THEN: N2=""
    ---------------------------------------------------------------------------------------IF D4 = 3 check J4.
    ----------------------------------------------------------------------------------------------------------IF J4 <-191 THEN: N2=""
    ----------------------------------------------------------------------------------------------------------IF J4 >-191 THEN: N2=K4
    --------------------------------------------------------------IF J3>-191 check if E3=W.
    ---------------------------------------------------------------------------------------IF E3<>W check J4.
    ----------------------------------------------------------------------------------------------------------IF J4 <-191 THEN: N2=K3.
    ----------------------------------------------------------------------------------------------------------IF J4 >-191 THEN: N2=((k4*3)+k3)
    ---------------------------------------------------------------------------------------IF E3= W THEN: N2=K3

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,654

    Re: Logic Tree to IF/AND Formula Conversion

    Post a xls file please
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Forum Contributor
    Join Date
    08-25-2013
    Location
    Virginia, USA
    MS-Off Ver
    Microsoft 365 Version 2409 64-bit
    Posts
    243

    Re: Logic Tree to IF/AND Formula Conversion

    Here is the file.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,654

    Re: Logic Tree to IF/AND Formula Conversion

    I don't have a clue

  5. #5
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,939

    Re: Logic Tree to IF/AND Formula Conversion

    =IF(AND( D2=1,E2="L"),IF(D3=2,IF(J3 >-191,IF(E3="W",K3,IF(J4 <-191,K3,(K4*3)+K3)),IF(D4=3,IF(J4 <-191,"",K4),"")),""),"")
    try this
    what is the impact if AND( D2=1,E2="L") is false

  6. #6
    Forum Contributor
    Join Date
    08-25-2013
    Location
    Virginia, USA
    MS-Off Ver
    Microsoft 365 Version 2409 64-bit
    Posts
    243

    Re: Logic Tree to IF/AND Formula Conversion

    YOU GOT IT, 100%! THANKS! Is there a way that I can learn how to convert logic trees? Is there a book you bought or a website you use?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 07-10-2013, 11:06 AM
  2. formula logic
    By kysaul in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-03-2008, 12:47 PM
  3. formula logic..please help
    By Richard Flame in forum Excel General
    Replies: 3
    Last Post: 01-30-2007, 06:47 PM
  4. Logic Tree, MS help = useless
    By roffler in forum Excel Formulas & Functions
    Replies: 63
    Last Post: 09-06-2005, 07:05 PM
  5. [SOLVED] Help with Formula logic
    By ciccia in forum Excel General
    Replies: 1
    Last Post: 07-20-2005, 04:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1