Results 1 to 4 of 4

Thread: Nested Conditions
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Nested Conditions

    I have a dynamic table below, and I want the last column to display one of four things based on the third column:

    geo a b
    north 7.5 0.1 FALSE
    south 9.4 0.4
    west 7.0 0.3
    central 6.9 -0.1
    blank 5.8 -0.1
    blank 8.1 -0.6
    blank 7.6 0.8
    BLANK
    BLANK


    1. "BLANK" (IF FIRST COLUMN SAYS "BLANK")

    2. 1 (IF THIRD COLUMN VALUE IS >0.5)
    3. 0 (IF THIRD COLUMN VALUE IS BETWEEN -0.5 AND -1)
    4. -1 (IF THIRD COLUMN VALUE IS -1)

    This is the formula I used, but getting "FALSE" as my output.

    =IF(A2="BLANK","BLANK", IF(AND(C2<-0.5,C2>-1),0, IF(C2<-1,-1, IF(C2>0.5,1))))

    Any thoughts?

    Many thanks.[img][/img][/quote]

  2. #2
    Board Regular
    Join Date
    May 2002
    Location
    CT
    Posts
    2,915
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Nested Conditions

    The false comes from the last if condition, since you didn't specify what to do when this is hit, it defaults to false. The first four data points do not meet any of your 4 conditions, so they fall to the last if and produce the false. The last 5 meet condition 1 and should produce blank as the answer.

  3. #3
    Board Regular eliW's Avatar
    Join Date
    Mar 2002
    Posts
    1,923
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Nested Conditions

    Seti is right,
    Also what happens when values are between -0.5 - +0.5 ?

    Eli

  4. #4
    New Member
    Join Date
    Dec 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Nested Conditions

    duh, thanks!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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