title: Interpolate off a standard curve in Excel
body: <p>Most simple thing to do on paper, but somehow near impossible to work out in Excel.</p>
  
  <p>I need to interpolate off a standard curve in Excel.</p>
  
  <p>I have a standard curve and need to find an unknown concentration of a known absorbance.</p>
  
  <p>Just like this;
  <a href="http://class.fst.ohio-state.edu/fst601/Lectures/spectt/Image161.gif" rel="nofollow">http://class.fst.ohio-state.edu/fst601/Lectures/spectt/Image161.gif</a></p>
  
  <p>My lecturer would not give us any more hints than to either use the, linear regression equation (which i think i worked out but couldn't get it to calculate the concentration) or use the point finding/picking option (no idea what this could mean)</p>
  
  <p>If anyone could help me out with this I would really appreciate it, and so would my whole class!</p>