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

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



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


--

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