Re: use the OR function inside an IF function

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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
    ... (replace somewhere in email address with gmail if mailing direct) ... "Bob Phillips" wrote: ... "Inbar" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Formulas as text or zero
    ... "Inbar" wrote: ... >> I have a spreadsheet that when I try and enter in a formula all that shows is ... >> cell, all I get is zero. ...
    (microsoft.public.excel.misc)
  • Re: Quality Control Macro -- Formula Anamolies
    ... to gmail if mailing direct) ... Sets the cursor to cell A1 ... I plan to just calculate a total for each worksheet, ...
    (microsoft.public.excel.programming)
  • Re: entering date dd/mmm/yyyy in VB gives mmm/dd/yyyy
    ... to gmail if mailing direct) ... The below will work for cell values stored as dates but not cell values ... Cells= NewDate ...
    (microsoft.public.excel.programming)
  • Re: Should be a easy How do I
    ... (replace somewhere in email address with gmail if mailing direct) ... "Target" are not the only text in the cell so I need a formula that would ...
    (microsoft.public.excel.newusers)