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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:869AE5AD-B496-46D5-BF7B-C63BAD92EDAB@xxxxxxxxxxxxxxxx
=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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F6103DBA-9404-4B14-A50F-9609571DC8A2@xxxxxxxxxxxxxxxx
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")





.

Relevant Pages

  • Re: use the OR function inside an IF function
    ... "David Biddulph" wrote: ... =leftwill return a text string, whereas your OR formula is looking ... "Bob Phillips" wrote: ... "Inbar" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Formating string as "#,###.00"
    ... "Bob Phillips" wrote: ... Dim i As Long, iStart As Long, iEnd As Long ... Dim str1 As String ... UserForm1.Show vbModeless ...
    (microsoft.public.excel.programming)
  • Re: Problems with reading / writing ini-file
    ... Private Declare Function apiGetWindowsDirectory& Lib "kernel32" Alias ... (ByVal lpbuffer As String, ByVal nSize As Long) ... "Bob Phillips" wrote: ... Dim sDir As String ...
    (microsoft.public.excel.programming)
  • Re: User defined file name on save
    ... "Bob Phillips" wrote: ... Dim sFileFirst As String ... Dim sFilename As String ...
    (microsoft.public.excel.misc)
  • Re: Formating string as "#,###.00"
    ... "Bob Phillips" wrote: ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... Dim i As Long, iStart As Long, iEnd As Long ... Dim str1 As String ...
    (microsoft.public.excel.programming)