title: EXCEL Multiple Ranges - need different answers for each range
body: <p>I have spent a few hours working out how to do this which is why im posting it here now... If you want to return different values in a cell based on which range the value entered in another cell comes under then I have worked out how to do it!! (bear in mind that this is specific to my spreadsheet and was for calculating prices i.e. 0.99 = £0.99)</p>
  
  <p>For example:</p>
  
  <ol>
  <li>IF G2 is ABOVE "0" BUT BELOW "1" THEN display "0.1"</li>
  <li>IF G2 is ABOVE "0.99" BUT BELOW "5" THEN display "0.15"</li>
  <li>IF G2 is ABOVE "4.99" BUT BELOW "15" THEN display "0.2"</li>
  <li>IF G2 is ABOVE "14.99" BUT BELOW "30" THEN display "0.5"</li>
  <li>IF G2 is ABOVE "29.99" BUT BELOW "100" THEN display "1.0"</li>
  <li>IF G2 is ABOVE "99.99" THEN display "1.30"</li>
  </ol>
  
  <p>So IF G2 was "£18.75" then the cell that <strong>this</strong> formula is entered in would display "£0.50" based on the value's above.</p>
  
  <p>You will see the above formula contained within the answer to this question below......</p>