Geek asks and answers

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

This is probably a pretty simple thing, but I am browsing the internet and have tried several ways to do this to no avail. This is my spreadsheet A1 - Form A2 - Text A3 - Logical A4 - Logic A5 - Logic Cells A3, A4 and A5 contain true or false. Is it possible to return true or false to cell A1 if any of A3, A4 and A5 contains true at least once or false if they all contain false?

Thanks so much if you can help!

+3
source share
2 answers

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

=OR(A3:A5)
+6
source

Use this formula for this purpose:

=OR(A2:A5)
+3
source

More articles:


All Articles