One way:

=(A1="Green") * (B1 = "Blue")

In article ,
Spendtoomuchtime wrote:

Having difficulty with IF two cells are true.

Example, I want D1 to = C1 if, A1="Green" and B1="Blue"

D1 can also equal a value instead of equaling C1, say equal 1 if True and 0
if False. The problem I am having is it will equal 1 if either A1 or B1 are
True, need both to be True to value 1 (or C1, really either way would work
for my purposes).