# use the OR function inside an IF function

1. ## 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. ## 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. ## 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. ## RE: use the OR function inside an IF function

My Mistake:
The cell no was wrong.

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. ## 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. ## 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. ## 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. ## 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. ## 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
> =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. ## 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
> =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. ## 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
> > =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")
> >>
> >>
> >>

>
>
>

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

#### 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