title: Excel formula for 2 scales
body: <p>I am trying to write a formula in excel for the following problem - </p>
  
  <ol>
  <li><p>There are 2 scales, one from 85% - 93% &amp; the other from 91%-94%</p></li>
  <li><p>At 85% &amp; 91% on 2 scales, the answer is 50%, similarly at 93% &amp; 94% on 2 scales the answer is 71%.</p></li>
  <li><p>I am not able to write a formula in a way that if the values on these scales lie in between these numbers i.e 86% &amp; 92% respectively, I get one answer (assuming the increase is linear).</p></li>
  </ol>
  
  <p>I can do it with only 1 scale. i.e if value is b/w 85%-93% at 94% on the other scale.
  The formula for one scale is follows - </p>
  
  <pre><code>If(value &lt; 93%),( value - 85%)/ (93% - 85%) * (71% - 58%) + 58%, NA
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/iqMMe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iqMMe.png" alt=""></a></p>
  
  <p>I need to write a formula in which if i have a value of 86% and 92% on the 2 scales, I get one value from the table.</p>
  
  <p>Please help</p>