is there an "IF-OR" function??

S

sokevin

Hi,

I need to do this in Column D

If column B= Column A, then Column D = "abc"

OR

if column C = Column A, then Column D = "xyz"


thanks :
 
J

Jason Morin

=IF(A1=B1,"abc",IF(A1=C1,"xyz","no match"))

Note: If both condition are met, "abc" will be returned.

HTH
Jason
Atlanta, GA
 
A

AlfD

Hi!

A formula with nested ifs will do it (in general).

e.g. =IF(A1=B1,"abc",IF(A1=C1,"xyz","")).

(I find it helps to read the line as " if A1=B1 put abc; otherwise i
A1=C1 put xyz; otherwise put nothing".)

But you don't seem to have decided what should happen if A1=B1=C1. I
it "abc" or "xyz"?

Maybe it can't happen and doesn't matter.

Al
 
S

sokevin

hi!

thanks for that alfie. i will try that....

my values in colB and colC are constants

thanks

kevi
 
A

AlfD

Kev

You're welcome.

I hate the name alfie: reminds me of a very uncomfortable film.

That's what it's all about...

Al
 
Top