title: Excel if statement to display if anything is in the row
body: <p>I don't really know how to search for this question or an appropriate title, so I hope that this will make sense.</p>
  
  <p>I'm trying to construct an Excel spreadsheet to keep track of functions of a software that are currently have tests made for them. The spreadsheet looks something like below where A-F are placeholders for the tests and 1-5 are placeholders for functions.</p>
  
  <pre><code>|   | A | B | C | D | E | F |
  |:-:|---|---|---|---|---|---|
  | 1 | X |   |   |   |   | X |
  | 2 |   |   |   |   |   |   |
  | 3 |   | X |   |   |   |   |
  | 4 |   |   | X |   |   |   |
  | 5 |   |   |   | X | X |   |
  </code></pre>
  
  <p>I would like to have another column at the end that would do something like this:</p>
  
  <pre><code>|   | A | B | C | D | E | F | Tested? |
  |:-:|---|---|---|---|---|---|---------|
  | 1 | X |   |   |   |   | X |   Yes   |
  | 2 |   |   |   |   |   |   |   No    |
  | 3 |   | X |   |   |   |   |   Yes   |
  | 4 |   |   | X |   |   |   |   Yes   |
  | 5 |   |   |   | X | X |   |   Yes   |
  </code></pre>
  
  <p>where the final column is an if statement that will display a conditional string base on if there are <em>any</em> entries in the row. I know that Excel's IF statements work something like this <code>=IF(A1=10,"YES","NO")</code> but I can't think how I would construct an IF statement that would print <code>YES</code> or <code>NO</code> based on whether there are any entries at all in the row. </p>
  
  <p>EDIT: To add a little more detail. I've thought about constructing an IF statement like this: <code>=IF(SUM(C3:AI3)&gt;0, "YES", "NO")</code> and this works essentially if I use <code>1</code>s or <code>0</code>s instead of <code>X</code> or <code>O</code> but I'd rather use the latter. Or really I'd just rather use strings instead of integers.</p>