title: How to reference Value instead of formula in a formula using Excel?
body: <p>In <a href="https://en.wikipedia.org/wiki/Microsoft_Excel" rel="nofollow">Microsoft Excel</a> 2010/2013, I have five data columns as follows :</p>
  
  <pre><code>           | A  | B |  C   | D  |  E  |
            ------------------------------
    line 1   |  12|  7|  1.71|   5| 8.57|
  
  
  
  C1: it's a formula ==&gt; A1/B1, and it's formatted as two decimal places.
  </code></pre>
  
  <p>However, the formula of <code>E1</code> (which is <code>C1*D1</code>) gives 8.57 instead of 8.55, I figured out that Excel uses C1's formula instead of the displayed value, which is not my expectation!</p>
  
  <p>So how can I enforce Excel to use the value(displayed) of a cell instead of its formula, to calculate another formula?</p>
  
  <p><strong>Note:</strong> I can get around by using the following formula in <code>E1</code>:</p>
  
  <pre><code>ROUND(C1,2)*D1
  </code></pre>
  
  <p>...but I want a solution which gets the displayed value directly without formatting the <code>C1</code> twice.</p>