MULTIPLE IF FUNCTION

  • Thread starter Thread starter MIKE
  • Start date Start date
M

MIKE

I am trying to put 2 different "IF(OR" functions in the
same cell and can't get it to work:

=IF(OR(D2=$K$2:$K$150),"In House"," ")+IF(OR
(D2=$M$2:$M$150),"Order"," ")....I am trying to have it
tell me that if D2 is anywhere in K2:K150, I have the
part "in house", but if D2 is anywhere in M2:M150, then I
need to order it.

It works fine with just one of them, but when I add the
second function, I get a #value error. Am I trying the
wrong function or have I put something in wrong?
 
The + operator errors out with #VALUE! if one of the operands is
text.

Use the concatenation operator, &, instead.
 
Mike;

you cannot add text, which is all your if statements will return.

from what you've said, i assume you know that k2:k150 and m2:m150 do not
contain the same part numbers, so it can't tell you that you have it 'in
house' and need to 'order it'.

=+IF(COUNTIF($K$2:$K$150,D2)>0,"In
House",IF(COUNTIF($M$2:$M$150,D2)>0,"Order",""))

will get the job done.
 
Back
Top