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

excel excel-formula worksheet-function
user3049027 picture user3049027 · Feb 26, 2014 · Viewed 23.7k times · Source

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!

Answer

Gary's Student picture Gary's Student · Feb 26, 2014

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

=OR(A3:A5)

Related questions

Convert date field into text in Excel

I have an Excel file which has a column formatted as date in the format dd-mm-YYYY. I need to convert that field to text. If I change the field type excel converts it to a strange value (like 40603). I tried …

Read More
Refer to a cell in another worksheet by referencing the current worksheet's name?

I plan to have a workbook with 24 sheets. The sheet names will be: Jan, Jan item, Feb, Feb item, etc. Basically it's for budgeting, with the month named sheet having summary info, and the ones with "item" in the name …

Read More
How to use VLOOKUP result as COUNTIF criteria

I want to be able to determine how many times a person's particular ID (e.g. #123) has appeared in a separate column (e.g. column C) given a name (e.g. Bob). I have: Let column A consist of several …

Read More