How do I use AND logic to check if cell A1 and cell B1 have certain text, to return a value in cell-CodePudding

Home > OS > How do I use AND logic to check if cell A1 and cell B1 have certain text, to return a value in cell

How do I use AND logic to check if cell A1 and cell B1 have certain text, to return a value in cell

Time：11-06

Looks like this:

A | B | C True | databasename.abc.flag | ?? IF(AND(A1"True",B1="flag"),"Success")

CodePudding user response：

Your formula looks close...does this get you what you're going for? In C1: =IF(AND(A1=TRUE,B1="flag"),"Success","Fail")

CodePudding user response：

You could try in C1:

=IF(AND(A1=TRUE,B1="flag"),"Success",""

This should return an empty cell in C column if conditions are not met.