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
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
for conditions
=IF(AND(A2=B2,C2=""),"File match","")
If alpha-numeric text in Column A = column B and Column C is blank, then the word "Filematch" is inserted into Column Dyou can use
=IF(AND(A2=B2,C2=""),"File
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I tried the solutions in the order I received them, and this is the one that worked. Thanks for the quick response!
Andrea
Andrea
=(IF(AND(A1=B1,C=''),"FILE
I think that would work pretty close to what you need