+ Reply to Thread
Results 1 to 4 of 4

If more than condition forumula

  1. #1
    Corey
    Guest

    If more than condition forumula

    I am trying to set up an IF calculation as below:
    =IF(L6="ABC",100,IF(L6="DEF",200,IF(L6="GHI",50)))
    The baove is fine but i now need a 2nd condition as below.

    I want to add a second condition to it say like:
    =IF(P6="" and L6="ABC",100,IF(P6="" and L6="DEF",200,IF(P6="" and
    L6="GHI",50, IF(P6="Yes" and L6="ABC",150, IF(P6="Yes" and L6=DEF",250,
    IF(P6="Yes" and L6="GHI",75))))))

    I try this but get an error.

    What syntax do i use other than (and) to include a 2nd condition ??


    Corey....



  2. #2
    Biff
    Guest

    Re: If more than condition forumula

    Hi!

    Here's one way:

    =IF(AND(P6="",L6<>""),VLOOKUP(L6,{"ABC",100;"DEF",200;"GHI",50},2,0),IF(AND(P6="Yes",L6<>""),VLOOKUP(L6,{"ABC",150;"DEF",250;"GHI",75},2,0),""))

    Biff

    "Corey" <coreymcconnell@splicetech.com.au> wrote in message
    news:eciwHEBlGHA.3720@TK2MSFTNGP03.phx.gbl...
    >I am trying to set up an IF calculation as below:
    > =IF(L6="ABC",100,IF(L6="DEF",200,IF(L6="GHI",50)))
    > The baove is fine but i now need a 2nd condition as below.
    >
    > I want to add a second condition to it say like:
    > =IF(P6="" and L6="ABC",100,IF(P6="" and L6="DEF",200,IF(P6="" and
    > L6="GHI",50, IF(P6="Yes" and L6="ABC",150, IF(P6="Yes" and L6=DEF",250,
    > IF(P6="Yes" and L6="GHI",75))))))
    >
    > I try this but get an error.
    >
    > What syntax do i use other than (and) to include a 2nd condition ??
    >
    >
    > Corey....
    >




  3. #3
    Corey
    Guest

    Re: If more than condition forumula

    You are a champ.
    Perfect.

    Thnx
    Corey....

    "Biff" <biffinpitt@comcast.net> wrote in message
    news:urw5PXBlGHA.4444@TK2MSFTNGP02.phx.gbl...
    > Hi!
    >
    > Here's one way:
    >
    > =IF(AND(P6="",L6<>""),VLOOKUP(L6,{"ABC",100;"DEF",200;"GHI",50},2,0),IF(AND(P6="Yes",L6<>""),VLOOKUP(L6,{"ABC",150;"DEF",250;"GHI",75},2,0),""))
    >
    > Biff
    >
    > "Corey" <coreymcconnell@splicetech.com.au> wrote in message
    > news:eciwHEBlGHA.3720@TK2MSFTNGP03.phx.gbl...
    >>I am trying to set up an IF calculation as below:
    >> =IF(L6="ABC",100,IF(L6="DEF",200,IF(L6="GHI",50)))
    >> The baove is fine but i now need a 2nd condition as below.
    >>
    >> I want to add a second condition to it say like:
    >> =IF(P6="" and L6="ABC",100,IF(P6="" and L6="DEF",200,IF(P6="" and
    >> L6="GHI",50, IF(P6="Yes" and L6="ABC",150, IF(P6="Yes" and L6=DEF",250,
    >> IF(P6="Yes" and L6="GHI",75))))))
    >>
    >> I try this but get an error.
    >>
    >> What syntax do i use other than (and) to include a 2nd condition ??
    >>
    >>
    >> Corey....
    >>

    >
    >




  4. #4
    Biff
    Guest

    Re: If more than condition forumula

    You're welcome!

    Biff

    "Corey" <coreymcconnell@splicetech.com.au> wrote in message
    news:uMct4vBlGHA.408@TK2MSFTNGP03.phx.gbl...
    > You are a champ.
    > Perfect.
    >
    > Thnx
    > Corey....
    >
    > "Biff" <biffinpitt@comcast.net> wrote in message
    > news:urw5PXBlGHA.4444@TK2MSFTNGP02.phx.gbl...
    >> Hi!
    >>
    >> Here's one way:
    >>
    >> =IF(AND(P6="",L6<>""),VLOOKUP(L6,{"ABC",100;"DEF",200;"GHI",50},2,0),IF(AND(P6="Yes",L6<>""),VLOOKUP(L6,{"ABC",150;"DEF",250;"GHI",75},2,0),""))
    >>
    >> Biff
    >>
    >> "Corey" <coreymcconnell@splicetech.com.au> wrote in message
    >> news:eciwHEBlGHA.3720@TK2MSFTNGP03.phx.gbl...
    >>>I am trying to set up an IF calculation as below:
    >>> =IF(L6="ABC",100,IF(L6="DEF",200,IF(L6="GHI",50)))
    >>> The baove is fine but i now need a 2nd condition as below.
    >>>
    >>> I want to add a second condition to it say like:
    >>> =IF(P6="" and L6="ABC",100,IF(P6="" and L6="DEF",200,IF(P6="" and
    >>> L6="GHI",50, IF(P6="Yes" and L6="ABC",150, IF(P6="Yes" and L6=DEF",250,
    >>> IF(P6="Yes" and L6="GHI",75))))))
    >>>
    >>> I try this but get an error.
    >>>
    >>> What syntax do i use other than (and) to include a 2nd condition ??
    >>>
    >>>
    >>> Corey....
    >>>

    >>
    >>

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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