title: If or statement in excel that has 3 options
body: <p>I want to display data from 3 seperate cells in one sheet in a single cell in a different sheet in the same workbook.  I believe it would require an if or statement but not sure how to write it.</p>
  
  <p>Example: if B3 has data, then both B4 and B5 will be blank and the cell in the other sheet will display the B3 data </p>
  
  <p>Example: If B3 is blank, B4 has data and B5 is blank, then the cell in the other sheet would display the B4 data</p>
  
  <p>Example: If B3 is blank, B4 is blank and B5 has data, the cell in the other sheet would display the B5 data </p>
  
  <p>How do I go about writing this function?</p>