title: 3 condition IF formula Excel
body: <p>I'm looking to create an excel formula with 3 conditions.</p>
  
  <p>Here's what I'm looking for: </p>
  
  <p><code>D11</code> has a number (it is number of working hours). If the number is less than 4 (i.e. <code>&lt;=4</code>), then I want it to show a value in cell <code>B5</code>,<br>
  If the number is between 4 and 8 (i.e. <code>&gt;4 and &lt;=8</code>), then I want it to show a value in cell <code>B6</code>.<br>
  If the number is over 8, then I want it to show a value in cell <code>B7</code>.</p>
  
  <p>The cells in <code>B5, B6 and B7</code> contain the relevant renimeration for 4-hours shift, 8-hours shift and for overtime.</p>
  
  <p>This is what I have made:</p>
  
  <p><code>IF(D11&lt;4,"$B$5",IF(AND(D11&gt;=4,E9&lt;=8),"$B$6","$B$7"))</code>.</p>
  
  <p>The Formula always gives a message :</p>
  
  <blockquote>
    <p>"The formula you typed conains an error: - for information about fixing....;-to get assistance.....; - if you are not trying.......</p>
  </blockquote>
  
  <p>Please advise!</p>