Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 169
  • Last Modified:

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
0
Andreamary
Asked:
Andreamary
1 Solution
 
Kent FichtnerInformation Technology Systems SupervisorCommented:
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
0
 
helpfinderIT ConsultantCommented:
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","")
0
 
Santosh GuptaCommented:
Try this

=IF(AND(A11=B11,C11=""),"FileMatch",IF(AND(NOT(A11=""),B12=C11),"Unique Chart",""))
0
 
AndreamaryAuthor Commented:
I tried the solutions in the order I received them, and this is the one that worked. Thanks for the quick response!

Andrea
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now