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" 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" wrote in message
...
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=10 1,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")
|