Value if two cells are true

[Spendtoomuchtime]

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).

 

[Chris Premo]

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).

=IF(AND(A1="Green", B1="Blue"),C1,FALSE)


--

 

[JE McGimpsey]

One way:

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