Link to home
Start Free TrialLog in
Avatar of Andreamary
Andreamary

asked on

Formula that includes two conditions

I need a formula that includes both conditions below and that will populate Column D as follows:
If alpha-numeric text in Column A = column B and Column C is blank, then the word "Filematch" is inserted into Column D
If Column A is not blank, and alpha-numeric text in Column B = Column C, then the word "Unique chart" is inserted into Column D

Thanks!
Andrea
Avatar of Kent Fichtner
Kent Fichtner
Flag of United States of America image

I would say it would be close to

=(IF(AND(A1=B1,C=''),"FILE MATCH",IF(AND(A1<>'',B1=C1),"UNIQUE CHART",''),'')

I think that would work pretty close to what you need
for conditions
If alpha-numeric text in Column A = column B and Column C is blank, then the word "Filematch" is inserted into Column D
you can use
=IF(AND(A2=B2,C2=""),"Filematch","")
ASKER CERTIFIED SOLUTION
Avatar of Santosh Gupta
Santosh Gupta

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Andreamary
Andreamary

ASKER

I tried the solutions in the order I received them, and this is the one that worked. Thanks for the quick response!

Andrea