title: Excel/Formula limitation with 255 characters with if statement
body: <p>Good morning,
  I would like to check the cell to see if they are fall into A, B or C categories with the excel formula below,</p>
  
  <pre><code>=IF(CB3=0,"",
  (IF(N3="
  215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 324, 325, 326, 327, 328, 329, 330, 331, 336, ","A",
  
  IF(N3="215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, "B",
  
  IF(N3="301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 324, 325, 326, 327, 328, 329, 330, 331, 336, ","C",
  IF(LEN(N3)=0,"",LEFT(N3,(LEN(N3)-2))))))))
  </code></pre>
  
  <p>And I've seen 255 text limits error so that I can't process it, The excel said that I can utilize a CONCATENATE or &amp;, but have no idea what I can do with this. Any suggestions? Thanks much in advance!</p>