IF statement help

[mr. j]

I have one column A1-A4 which will have true or false text in them and I would like to be able to have A5 to say correct or incorrect based on the text in A1-A4:

A1- False
A2- False
A3- False
A4- False
A5- "Correct" if all the answers of A1-A4 are the same or "Incorrect" if the answers in A1-A4 are different.

 

[VoG]

Try

=IF(OR(COUNTIF(A1:A4,FALSE)=4,COUNTIF(A1:A4,TRUE)=4),"Correct","Incorrect")

 

[mr. j]

Try

=IF(OR(COUNTIF(A1:A4,FALSE)=4,COUNTIF(A1:A4,TRUE)=4),"Correct","Incorrect")

Thanks VoG, that's what I was looking for,

 

[Legacy 167133]

Well done Vog!

That was some good thinking. I was going to suggest to substitute the "False" with "" or zero, and if "True" with some value and take it from there with a Sum function for the range in question. By doing that you are not limited to only four rows of data, but could expand on it if needed.

 

[T. Valko]

I have one column A1-A4 which will have true or false text in them and I would like to be able to have A5 to say correct or incorrect based on the text in A1-A4:

A1- False
A2- False
A3- False
A4- False
A5- "Correct" if all the answers of A1-A4 are the same or "Incorrect" if the answers in A1-A4 are different.

Assuming that the range will contain only either TRUE or FALSE...

Try this...

=IF(COUNTIF(A1:A4,A1)<4,"Incorrect","Correct")

Note that if ALL the cells in the range are empty the formula will return Incorrect.

 

[mr. j]

Assuming that the range will contain only either TRUE or FALSE...

Try this...

=IF(COUNTIF(A1:A4,A1)<4,"Incorrect","Correct")

Note that if ALL the cells in the range are empty the formula will return Incorrect.

T. Valko is it possible to have it say no data if any of the cells are blank?

 

[T. Valko]

T. Valko is it possible to have it say no data if any of the cells are blank?

Yes, try this version:

=IF(COUNTIF(A1:A4,""),"No Data",IF(COUNTIF(A1:A4,A1)<4,"Incorrect","Correct"))