Excel formula to determine if any cells in a range contain a value

Question

This is probably quite a basic thing to do, but I've been looking around the internet and have tried several ways of doing it to no avail. This is my spreadsheet A1 - Blank A2 - Text A3 - Boolean A4 - Boolean A5 - Boolean Cells A3, A4 and A5 contain true or false. Is it possible to return a value of true or false in cell A1 if any of A3, A4 and A5 contain true at least once, or false if they all contain false?

Many thanks if you are able to help!

Solution 1

Consider..................:

=OR(A3:A5)

Solution 2

Use this formula for this purpose:

=OR(A2:A5)

Comments

[MichaelChirico]

How can this be done on-the-fly? =OR(A3:A5 > 5) is an error

[MichaelChirico]

Best way? =countif(A3:A5, ">5") > 0?

[Gary's Student]

@MichaelChirico Looks interesting!