title: Excel 2007 get value of cell for formula not reference
body: <p>I have a sheet of numerical data. I want to multiply values by scaling factors which are in other cells that I can change. What I would ideally like to do is a substitution like such (just an example):  </p>
  
  <p><code>22.85</code> becomes <code>=(F$15*22.85)</code>  </p>
  
  <p>I could do this easily in a script but I'd rather just stay in Excel. </p>
  
  <p>What I'm thinking would be easiest is to make a formula like <code>=(F$15*...)</code> and drag it out, but in place of '...' I want it to just get the value of the cell, not a reference to it. </p>
  
  <p>This is because I want to replace the cells, so a formula like <code>=(F$15*L4)</code> would be in cell L4 and referencing itself, which obviously wouldn't work. </p>
  
  <p>Thanks :)</p>