Microsoft is making Excel’s formulas easier
Will it give us beauts like this?:<p>=IFERROR(IF(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(SEARCH(&quot;Banner&quot;,AC5),SEARCH(&quot;EBL2&quot;,AC5)),SEARCH(&quot;Movie Art&quot;,AC5)),SEARCH(&quot;Use as is&quot;,AC5)),SEARCH(&quot;TTT&quot;,AC5)),SEARCH(&quot;Generic&quot;,AC5)),LEN(AC5)+1)&lt;IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(SEARCH(&quot;Banner&quot;,AC5),SEARCH(&quot;EBL2&quot;,AC5)),SEARCH(&quot;Movie Art&quot;,AC5)),SEARCH(&quot;Use as is&quot;,AC5)),SEARCH(&quot;TTT&quot;,AC5)),SEARCH(&quot;Generic&quot;,AC5)),LEN(AC5)+1),MID(AC5,IFERROR(IFERROR(IFERROR(SEARCH(&quot;Customs&quot;,AC5),SEARCH(&quot;Custom&quot;,AC5)),SEARCH(&quot;Generic&quot;,AC5)),LEN(AC5)+1),IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(SEARCH(&quot;Banner&quot;,AC5),SEARCH(&quot;EBL2&quot;,AC5)),SEARCH(&quot;Movie Art&quot;,AC5)),SEARCH(&quot;Use as is&quot;,AC5)),SEARCH(&quot;TTT&quot;,AC5)),SEARCH(&quot;Generic&quot;,AC5)),LEN(AC5)+1)-IFERROR(IFERROR(IFERROR(SEARCH(&quot;Customs&quot;,AC5),SEARCH(&quot;Custom&quot;,AC5)),SEARCH(&quot;Generic&quot;,AC5)),LEN(AC5)+1)),MID(AC5,IFERROR(IFERROR(IFERROR(SEARCH(&quot;Customs&quot;,AC5),SEARCH(&quot;Custom&quot;,AC5)),SEARCH(&quot;Generic&quot;,AC5)),LEN(AC5)+1),IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(SEARCH(&quot;Banner&quot;,AC5),SEARCH(&quot;EBL2&quot;,AC5)),SEARCH(&quot;Movie Art&quot;,AC5)),SEARCH(&quot;Use as is&quot;,AC5)),SEARCH(&quot;TTT&quot;,AC5)),SEARCH(&quot;Generic&quot;,AC5)),LEN(AC5)+1)-IFERROR(IFERROR(IFERROR(SEARCH(&quot;Customs&quot;,AC5),SEARCH(&quot;Custom&quot;,AC5)),SEARCH(&quot;Generic&quot;,AC5)),LEN(AC5)+1))),&quot;&quot;)<p>(source: <a href="https:&#x2F;&#x2F;www.quora.com&#x2F;What-is-the-longest-excel-formula-you-have-ever-created-for-one-cell" rel="nofollow">https:&#x2F;&#x2F;www.quora.com&#x2F;What-is-the-longest-excel-formula-you-...</a> )