title: Excel Multiple Range IF AND Formula
body: <p>I am trying to write an xl formula which tests a cell's, <code>L105</code> in this case, value against a range and when true applies a hard coded multiplier to the cells value, like this in pseudo code:</p>
  
  <ul>
  <li>If L105 == 1 then L105*1050</li>
  <li>If L105 2-5 then L105*750</li>
  <li>If L105 6-10 then L105*700</li>
  <li>IF L105 11-15 then L105*650</li>
  <li>IF L105 > 15 then L105*600</li>
  </ul>
  
  <p>So I have written this string of IF and AND statements, which I'm thinking should work ok, but does not and I cannot understand why not:</p>
  
  <p><code>=IF(L105=1),L105*1050,IF(AND(L105&gt;1,L105&lt;6),L105*750,IF(AND(L105&gt;5,L105&lt;11),L105*700,IF(AND(L105&gt;10,L105&lt;16),L105*650,IF(L105&gt;15),L105*600)))</code></p>
  
  <p>Can anyone tell me what's wrong with the above. Rather unhelpfully the 'error' that i get is a 'formula parse error'.</p>
  
  <p>Thanks</p>