title: How to rewrite excel formulas in a readable manner?
body: <p>I have an Excel file with formulas in this manner:</p>
  
  <p><code>=IF(OR(ISERROR(G16),ISERROR(G17)),X16,IF(OR(G16="xxx",G16="yyy",G16="zzz"),Y16,IF(G16="333","N\A",IF(G17="333",Z16,IF(D17="",IF((HEX2DEC(W$10)-HEX2DEC(W16))/VLOOKUP(F16,$M$36:$N$41,2,FALSE)&lt;0,0,(HEX2DEC(W$10)-HEX2DEC(W16))/VLOOKUP(F16,$M$36:$N$41,2,FALSE)), IF((HEX2DEC(W17)-HEX2DEC(W16))/VLOOKUP(F16,$M$36:$N$41,2,FALSE)&lt;0,0,(HEX2DEC(W17)-HEX2DEC(W16))/VLOOKUP(F16,$M$36:$N$41,2,FALSE)))))))</code></p>
  
  <p>I would like to simplify them so it will be written in a more readable manner.</p>
  
  <ul>
  <li>Can I edit/write Excel formulas in indented way?</li>
  <li>What kind of simplifications can I do? </li>
  <li>Should I use an VBA script instead of Excel's formulas?</li>
  </ul>