title: Several conditions with IF
body: <p>i have a data set in Excel where in the 1st column there is and ID with 12 characters in which i must change from 1 to -1 if the first 6 characters from left to right has several conditions.</p>
  <p>I have tried the following, but i cant get it work with out using VBA</p>
  <pre><code>=IFT((LEF([@Cuenta],6)=AND(&quot;503-01&quot;,&quot;503-02&quot;,&quot;503-50&quot;,&quot;503-60&quot;)),-1,A847)
  </code></pre>
  <p>I would like to make it as short as possible cause the person that works with the sheet gets confused with long formulas</p>