IF Statement Advice

[Dom Newton]

Hi all

I wonder if someone can help me with a spreadsheet I'm building.

Basically what I'm trying to do is create a summary table of
information held on the spreadie. I want Excel to look at the
contents of two separate cells, and if they both contain the "correct"
data, to input a numeral "1" into a cell. If the cells don't contain
the correct data I want the cell to remain blank or display a zero.

Can anyone help ?

Thanks very much

Dom

 

[Paul Corrado]

=IF(AND(A1="correct",B1="correct"),1,"")

 

[Dave Peterson]

Could it be something like this?

=if(and(a1="ok",b1="correct"),1,0)

dragged down the column.

 

[Guest]

Hi
maybe
=IF(AND(A1="value1",B1="value2"),1,0)