title: c# npoi excel How to get a cell's formula VALUE?
body: <p>I set a formula on some cells in a loop like this:</p>
  
  <pre><code>System.String fm = "IF(B2,J2=J1,FALSE)"
  another.GetRow(0).CreateCell(28).SetCellFormula(fm); 
  </code></pre>
  
  <p>I always wondered how to get the result (value) of this formula and not copy the entire formula.</p>
  
  <pre><code>MessageBox.Show(another.GetRow(0).GetCell(28).ToString);
  </code></pre>
  
  <p>it dislplay value IF(B2,J2=J1,FALSE)</p>
  
  <p>how can get the result (value) not formula?</p>