I am trying to display a chart using the values obtained from cells that have formulas. The values calculated by the formula appear on the worksheet correctly. I would like to copy just the numeric value of these cells to another cell on the worksheet.

Everytime I try to obtain the cell value it outputs a null value or a 0. Is it possible to obtain the numeric value?