Value if two cells are true

S

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

Chris Premo

Spendtoomuchtime said:
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).
Click to expand...



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


--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statement for a range of cells 3
Nested IF Help 3
if(a1=b1=c1,1,0) is 0 when should be 1, why? 3
Assistance for the IF Function 3
Different cells that need to sum in one 4
Return true if multiple cells are the same 2
Excel 2007 storing the high and low 3
copy and paste the cell with formula ="1" 3

Top