+ Reply to Thread
Results 1 to 11 of 11

use the OR function inside an IF function

  1. #1
    Inbar
    Guest

    use the OR function inside an IF function

    Hi,

    I am trying to use the OR function within an IF condition.
    when I use each function seperatly, it works fine. but both functions
    together always return the value of "B" - as false result, even when the
    requested cell holds one of the true values.

    for example:
    =IF(B18=OR(148,150),"A","B")

  2. #2
    Paul Mathews
    Guest

    RE: use the OR function inside an IF function

    =IF(OR(B18=148,B18=150),"A","B")

    "Inbar" wrote:

    > Hi,
    >
    > I am trying to use the OR function within an IF condition.
    > when I use each function seperatly, it works fine. but both functions
    > together always return the value of "B" - as false result, even when the
    > requested cell holds one of the true values.
    >
    > for example:
    > =IF(B18=OR(148,150),"A","B")


  3. #3
    Inbar
    Guest

    RE: use the OR function inside an IF function

    Thanks Paul,
    It helped!
    now when I combine this condition within a long and detailed IF condition.
    it has a problem:

    =IF(OR(B13=148,B13=149,B13=1501),"Mellon",IF(OR(B13=101,B13=102),"Watermelon",IF(B13=184,"Squash",IF(OR(B13=153,B13=154),"Cucumber",IF(OR(B13=173,B13=174,B13=175),"Peper",IF(OR(B13=163,B13=164,B13=165,B13=166),"Tomato","N/A"))))))

    the result I'm getting is "N/A" although the cell value is 101. maybe you
    see the problem?

    "Paul Mathews" wrote:

    > =IF(OR(B18=148,B18=150),"A","B")
    >
    > "Inbar" wrote:
    >
    > > Hi,
    > >
    > > I am trying to use the OR function within an IF condition.
    > > when I use each function seperatly, it works fine. but both functions
    > > together always return the value of "B" - as false result, even when the
    > > requested cell holds one of the true values.
    > >
    > > for example:
    > > =IF(B18=OR(148,150),"A","B")


  4. #4
    Inbar
    Guest

    RE: use the OR function inside an IF function

    My Mistake:
    The cell no was wrong.
    So thanks for your help!

    Inbar

    "Paul Mathews" wrote:

    > =IF(OR(B18=148,B18=150),"A","B")
    >
    > "Inbar" wrote:
    >
    > > Hi,
    > >
    > > I am trying to use the OR function within an IF condition.
    > > when I use each function seperatly, it works fine. but both functions
    > > together always return the value of "B" - as false result, even when the
    > > requested cell holds one of the true values.
    > >
    > > for example:
    > > =IF(B18=OR(148,150),"A","B")


  5. #5
    Bob Phillips
    Guest

    Re: use the OR function inside an IF function

    I get Watermelon as expected. You don't have spaces in the cell at all?

    --
    HTH

    Bob Phillips

    (replace somewhere in email address with gmail if mailing direct)

    "Inbar" <Inbar@discussions.microsoft.com> wrote in message
    news:2AB964E0-FA58-43A6-AF23-63754CACB9A2@microsoft.com...
    > Thanks Paul,
    > It helped!
    > now when I combine this condition within a long and detailed IF condition.
    > it has a problem:
    >
    >

    =IF(OR(B13=148,B13=149,B13=1501),"Mellon",IF(OR(B13=101,B13=102),"Watermelon
    ",IF(B13=184,"Squash",IF(OR(B13=153,B13=154),"Cucumber",IF(OR(B13=173,B13=17
    4,B13=175),"Peper",IF(OR(B13=163,B13=164,B13=165,B13=166),"Tomato","N/A"))))
    ))
    >
    > the result I'm getting is "N/A" although the cell value is 101. maybe you
    > see the problem?
    >
    > "Paul Mathews" wrote:
    >
    > > =IF(OR(B18=148,B18=150),"A","B")
    > >
    > > "Inbar" wrote:
    > >
    > > > Hi,
    > > >
    > > > I am trying to use the OR function within an IF condition.
    > > > when I use each function seperatly, it works fine. but both functions
    > > > together always return the value of "B" - as false result, even when

    the
    > > > requested cell holds one of the true values.
    > > >
    > > > for example:
    > > > =IF(B18=OR(148,150),"A","B")




  6. #6
    Inbar
    Guest

    RE: use the OR function inside an IF function

    The column B8 does not recognize the value 101 because there is a condition
    on the B8 column. when I remove the condition and simply write the vlaue 101,
    the function works.

    =IF(OR(B8=148,B8=149,B8=1501),"Mellon",IF(OR(B8=101,B8=102),"Watermelon",IF(B8=184,"Squash",IF(OR(B8=153,B8=154),"Cucumber",IF(OR(B8=173,B8=174,B8=175),"Peper",IF(OR(B8=163,B8=164,B8=165,B8=166),"Tomato","N/A"))))))

    any idea what to do?

    "Inbar" wrote:

    > My Mistake:
    > The cell no was wrong.
    > So thanks for your help!
    >
    > Inbar
    >
    > "Paul Mathews" wrote:
    >
    > > =IF(OR(B18=148,B18=150),"A","B")
    > >
    > > "Inbar" wrote:
    > >
    > > > Hi,
    > > >
    > > > I am trying to use the OR function within an IF condition.
    > > > when I use each function seperatly, it works fine. but both functions
    > > > together always return the value of "B" - as false result, even when the
    > > > requested cell holds one of the true values.
    > > >
    > > > for example:
    > > > =IF(B18=OR(148,150),"A","B")


  7. #7
    Bob Phillips
    Guest

    Re: use the OR function inside an IF function

    What sort of condition?

    --
    HTH

    Bob Phillips

    (replace somewhere in email address with gmail if mailing direct)

    "Inbar" <Inbar@discussions.microsoft.com> wrote in message
    news:F6103DBA-9404-4B14-A50F-9609571DC8A2@microsoft.com...
    > The column B8 does not recognize the value 101 because there is a

    condition
    > on the B8 column. when I remove the condition and simply write the vlaue

    101,
    > the function works.
    >
    >

    =IF(OR(B8=148,B8=149,B8=1501),"Mellon",IF(OR(B8=101,B8=102),"Watermelon",IF(
    B8=184,"Squash",IF(OR(B8=153,B8=154),"Cucumber",IF(OR(B8=173,B8=174,B8=175),
    "Peper",IF(OR(B8=163,B8=164,B8=165,B8=166),"Tomato","N/A"))))))
    >
    > any idea what to do?
    >
    > "Inbar" wrote:
    >
    > > My Mistake:
    > > The cell no was wrong.
    > > So thanks for your help!
    > >
    > > Inbar
    > >
    > > "Paul Mathews" wrote:
    > >
    > > > =IF(OR(B18=148,B18=150),"A","B")
    > > >
    > > > "Inbar" wrote:
    > > >
    > > > > Hi,
    > > > >
    > > > > I am trying to use the OR function within an IF condition.
    > > > > when I use each function seperatly, it works fine. but both

    functions
    > > > > together always return the value of "B" - as false result, even when

    the
    > > > > requested cell holds one of the true values.
    > > > >
    > > > > for example:
    > > > > =IF(B18=OR(148,150),"A","B")




  8. #8
    Inbar
    Guest

    Re: use the OR function inside an IF function

    =left(B7,3)

    B8 holds this condition in order to cut the left 3 numbers from the value in
    B7.

    "Bob Phillips" wrote:

    > What sort of condition?
    >
    > --
    > HTH
    >
    > Bob Phillips
    >
    > (replace somewhere in email address with gmail if mailing direct)
    >
    > "Inbar" <Inbar@discussions.microsoft.com> wrote in message
    > news:F6103DBA-9404-4B14-A50F-9609571DC8A2@microsoft.com...
    > > The column B8 does not recognize the value 101 because there is a

    > condition
    > > on the B8 column. when I remove the condition and simply write the vlaue

    > 101,
    > > the function works.
    > >
    > >

    > =IF(OR(B8=148,B8=149,B8=1501),"Mellon",IF(OR(B8=101,B8=102),"Watermelon",IF(
    > B8=184,"Squash",IF(OR(B8=153,B8=154),"Cucumber",IF(OR(B8=173,B8=174,B8=175),
    > "Peper",IF(OR(B8=163,B8=164,B8=165,B8=166),"Tomato","N/A"))))))
    > >
    > > any idea what to do?
    > >
    > > "Inbar" wrote:
    > >
    > > > My Mistake:
    > > > The cell no was wrong.
    > > > So thanks for your help!
    > > >
    > > > Inbar
    > > >
    > > > "Paul Mathews" wrote:
    > > >
    > > > > =IF(OR(B18=148,B18=150),"A","B")
    > > > >
    > > > > "Inbar" wrote:
    > > > >
    > > > > > Hi,
    > > > > >
    > > > > > I am trying to use the OR function within an IF condition.
    > > > > > when I use each function seperatly, it works fine. but both

    > functions
    > > > > > together always return the value of "B" - as false result, even when

    > the
    > > > > > requested cell holds one of the true values.
    > > > > >
    > > > > > for example:
    > > > > > =IF(B18=OR(148,150),"A","B")

    >
    >
    >


  9. #9
    Bob Phillips
    Guest

    Re: use the OR function inside an IF function

    Change that to

    =--LEFT(B7,3)

    then

    --
    HTH

    Bob Phillips

    (replace somewhere in email address with gmail if mailing direct)

    "Inbar" <Inbar@discussions.microsoft.com> wrote in message
    news:869AE5AD-B496-46D5-BF7B-C63BAD92EDAB@microsoft.com...
    > =left(B7,3)
    >
    > B8 holds this condition in order to cut the left 3 numbers from the value

    in
    > B7.
    >
    > "Bob Phillips" wrote:
    >
    > > What sort of condition?
    > >
    > > --
    > > HTH
    > >
    > > Bob Phillips
    > >
    > > (replace somewhere in email address with gmail if mailing direct)
    > >
    > > "Inbar" <Inbar@discussions.microsoft.com> wrote in message
    > > news:F6103DBA-9404-4B14-A50F-9609571DC8A2@microsoft.com...
    > > > The column B8 does not recognize the value 101 because there is a

    > > condition
    > > > on the B8 column. when I remove the condition and simply write the

    vlaue
    > > 101,
    > > > the function works.
    > > >
    > > >

    > >

    =IF(OR(B8=148,B8=149,B8=1501),"Mellon",IF(OR(B8=101,B8=102),"Watermelon",IF(
    > >

    B8=184,"Squash",IF(OR(B8=153,B8=154),"Cucumber",IF(OR(B8=173,B8=174,B8=175),
    > > "Peper",IF(OR(B8=163,B8=164,B8=165,B8=166),"Tomato","N/A"))))))
    > > >
    > > > any idea what to do?
    > > >
    > > > "Inbar" wrote:
    > > >
    > > > > My Mistake:
    > > > > The cell no was wrong.
    > > > > So thanks for your help!
    > > > >
    > > > > Inbar
    > > > >
    > > > > "Paul Mathews" wrote:
    > > > >
    > > > > > =IF(OR(B18=148,B18=150),"A","B")
    > > > > >
    > > > > > "Inbar" wrote:
    > > > > >
    > > > > > > Hi,
    > > > > > >
    > > > > > > I am trying to use the OR function within an IF condition.
    > > > > > > when I use each function seperatly, it works fine. but both

    > > functions
    > > > > > > together always return the value of "B" - as false result, even

    when
    > > the
    > > > > > > requested cell holds one of the true values.
    > > > > > >
    > > > > > > for example:
    > > > > > > =IF(B18=OR(148,150),"A","B")

    > >
    > >
    > >




  10. #10
    David Biddulph
    Guest

    Re: use the OR function inside an IF function

    I guess that your problem may be that
    =left(B7,3) will return a text string, whereas your OR formula is looking
    for the number 101.

    I think you'll find that it will work if you use =VALUE(LEFT(B7,3))

    David Biddulph

    "Inbar" <Inbar@discussions.microsoft.com> wrote in message
    news:869AE5AD-B496-46D5-BF7B-C63BAD92EDAB@microsoft.com...
    > =left(B7,3)
    >
    > B8 holds this condition in order to cut the left 3 numbers from the value
    > in
    > B7.
    >
    > "Bob Phillips" wrote:
    >
    >> What sort of condition?
    >>
    >> --
    >> HTH
    >>
    >> Bob Phillips
    >>
    >> (replace somewhere in email address with gmail if mailing direct)
    >>
    >> "Inbar" <Inbar@discussions.microsoft.com> wrote in message
    >> news:F6103DBA-9404-4B14-A50F-9609571DC8A2@microsoft.com...
    >> > The column B8 does not recognize the value 101 because there is a

    >> condition
    >> > on the B8 column. when I remove the condition and simply write the
    >> > vlaue

    >> 101,
    >> > the function works.
    >> >
    >> >

    >> =IF(OR(B8=148,B8=149,B8=1501),"Mellon",IF(OR(B8=101,B8=102),"Watermelon",IF(
    >> B8=184,"Squash",IF(OR(B8=153,B8=154),"Cucumber",IF(OR(B8=173,B8=174,B8=175),
    >> "Peper",IF(OR(B8=163,B8=164,B8=165,B8=166),"Tomato","N/A"))))))
    >> >
    >> > any idea what to do?
    >> >
    >> > "Inbar" wrote:
    >> >
    >> > > My Mistake:
    >> > > The cell no was wrong.
    >> > > So thanks for your help!
    >> > >
    >> > > Inbar
    >> > >
    >> > > "Paul Mathews" wrote:
    >> > >
    >> > > > =IF(OR(B18=148,B18=150),"A","B")
    >> > > >
    >> > > > "Inbar" wrote:
    >> > > >
    >> > > > > Hi,
    >> > > > >
    >> > > > > I am trying to use the OR function within an IF condition.
    >> > > > > when I use each function seperatly, it works fine. but both

    >> functions
    >> > > > > together always return the value of "B" - as false result, even
    >> > > > > when

    >> the
    >> > > > > requested cell holds one of the true values.
    >> > > > >
    >> > > > > for example:
    >> > > > > =IF(B18=OR(148,150),"A","B")

    >>
    >>
    >>




  11. #11
    Inbar
    Guest

    Re: use the OR function inside an IF function

    Well Done David!

    its working now. thanks a lot.

    inbar

    "David Biddulph" wrote:

    > I guess that your problem may be that
    > =left(B7,3) will return a text string, whereas your OR formula is looking
    > for the number 101.
    >
    > I think you'll find that it will work if you use =VALUE(LEFT(B7,3))
    >
    > David Biddulph
    >
    > "Inbar" <Inbar@discussions.microsoft.com> wrote in message
    > news:869AE5AD-B496-46D5-BF7B-C63BAD92EDAB@microsoft.com...
    > > =left(B7,3)
    > >
    > > B8 holds this condition in order to cut the left 3 numbers from the value
    > > in
    > > B7.
    > >
    > > "Bob Phillips" wrote:
    > >
    > >> What sort of condition?
    > >>
    > >> --
    > >> HTH
    > >>
    > >> Bob Phillips
    > >>
    > >> (replace somewhere in email address with gmail if mailing direct)
    > >>
    > >> "Inbar" <Inbar@discussions.microsoft.com> wrote in message
    > >> news:F6103DBA-9404-4B14-A50F-9609571DC8A2@microsoft.com...
    > >> > The column B8 does not recognize the value 101 because there is a
    > >> condition
    > >> > on the B8 column. when I remove the condition and simply write the
    > >> > vlaue
    > >> 101,
    > >> > the function works.
    > >> >
    > >> >
    > >> =IF(OR(B8=148,B8=149,B8=1501),"Mellon",IF(OR(B8=101,B8=102),"Watermelon",IF(
    > >> B8=184,"Squash",IF(OR(B8=153,B8=154),"Cucumber",IF(OR(B8=173,B8=174,B8=175),
    > >> "Peper",IF(OR(B8=163,B8=164,B8=165,B8=166),"Tomato","N/A"))))))
    > >> >
    > >> > any idea what to do?
    > >> >
    > >> > "Inbar" wrote:
    > >> >
    > >> > > My Mistake:
    > >> > > The cell no was wrong.
    > >> > > So thanks for your help!
    > >> > >
    > >> > > Inbar
    > >> > >
    > >> > > "Paul Mathews" wrote:
    > >> > >
    > >> > > > =IF(OR(B18=148,B18=150),"A","B")
    > >> > > >
    > >> > > > "Inbar" wrote:
    > >> > > >
    > >> > > > > Hi,
    > >> > > > >
    > >> > > > > I am trying to use the OR function within an IF condition.
    > >> > > > > when I use each function seperatly, it works fine. but both
    > >> functions
    > >> > > > > together always return the value of "B" - as false result, even
    > >> > > > > when
    > >> the
    > >> > > > > requested cell holds one of the true values.
    > >> > > > >
    > >> > > > > for example:
    > >> > > > > =IF(B18=OR(148,150),"A","B")
    > >>
    > >>
    > >>

    >
    >
    >


+ 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