title: Excel Nested If Formula Error - ANDIF
body: <p>Basically, if the value to be inputted (F33) is upto the amount in column A, it gets multiplied by the rate(%) next to it. However, this changes when the value is above 60k; there are two possibilities after 60k (which I inputted into the formula below. However, excel keeps giving me an error and I do not know what the error is? Can anyone spot it? I would be grateful, it has been bugging me for a hours now. 
  Should I try to put formulas in different cells for values above 60k and then 'call' those cells, instead of putting them directly into the formula? I am not really sure what is failing this argument:
  A40: 11000, A41: 27,000, A42: 60000, A43: 97000</p>
  
  <pre><code>'=if(AND($F$33&gt;0,$F$33&lt;$A$40),$F$33*B40,IF(AND($F$33&gt;$A$40,$F$33&lt;$A$41),$F$33*$B$41,IF(AND($F$33&gt;$A$41,$F$33&lt;$A$42),$F$33*$B$42,IF(AND($F$33&gt;$A$42,$F$33&lt;$A$43),(13760+(($F$33-60000)*0.35)),IF(AND($F$33&gt;$A$43,(23750+(($F$33-97000)*0.35))))))))
  </code></pre>