title: What does Info!$D$7 mean in Excel?
body: <p>What does this mean?</p>
  
  <pre><code>Info!$D$7="Metric"
  </code></pre>
  
  <p>Full cell:</p>
  
  <pre><code>=IF(Info!$D$7="Metric","m3/h","gpm")
  </code></pre>
  
  <p>No matter what I seem to put into cell D7 (i.e. <code>Metric</code>), the value of the cell containing the above formula, does not change.  Searching info on Excel IF statement does not seem to offer help.</p>