title: Sharepoint calculated column returning #Name?
body: <p>I have a SharePoint calculated column that is as follows:</p>
  
  <pre><code>=RIGHT(Hip,LEN(Hip)-INT(FIND("-",Hip)))
  </code></pre>
  
  <p>Basically what this does is return the last digits after the "-" in a string, but for strings that do not contain a "-" it returns #Name? into the column.  Does anyone know of an easy way to change this formula to make it say what I want? Or is it just easier to re-think the formula all together.  Thanks guys.</p>