title: Excel formula to determine if any cells in a range contain a value
body: <p>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? </p>
  
  <p>Many thanks if you are able to help!</p>