title: Excel formula has too many arguments
body: <p>I created the below formula to run of a series of customer numbers saved in text format.</p>
  
  <pre><code>=IFERROR(IF(AND((LEFT($J3,3)="028"),$N3=11),"NI Landline",IF(AND((LEFT($J3,2)="07"),$N3=11),"Mobile","Other Number")),"Other Number")
  </code></pre>
  
  <p>Breakdown:</p>
  
  <pre><code>=IFERROR(
      IF(AND((LEFT($J3,3)="028"),$N3=11),
          "NI Landline",
      IF(AND((LEFT($J3,2)="07"),$N3=11),
          "Mobile",
      "Other Number")),
  "Other Number")
  </code></pre>
  
  <p>This formula works fine but I needed to amend it slightly to differentiate the numbers a bit further, so I amended it to the below:</p>
  
  <pre><code>=IFERROR(IF(AND((LEFT($J2,3)="028"),$N2=11),"NI Landline",IF(AND((LEFT($J2,2)="07"),$N2=11),"UK Mobile",IF(AND((LEFT($J2,5)="00353"),$N2=14),"ROI Number","Other Number")),"Other Number")
  </code></pre>
  
  <p>Breakdown:</p>
  
  <pre><code>=IFERROR(
      IF(AND((LEFT($J2,3)="028"),$N2=11),
          "NI Landline",
      IF(AND((LEFT($J2,2)="07"),$N2=11),
          "UK Mobile",
      IF(AND((LEFT($J2,5)="00353"),$N2=14),
          "ROI Number",
      "Other Number")),
  ="Other Number")
  </code></pre>
  
  <p>Thinking I've replicated the conditions from the first 'IF' sections, I ran the formula and it returned 'too many arguments'. I've removed the new section so that it is the same as the first formula, and it works fine. I've checked the parentheses but the number matches on both sides. Any ideas?</p>
  
  <p>I'm hoping it is something stupid, any assistance would be greatly appreciated!
  Thanks
  Liam</p>