Cell Value in Formula Cells

[Suraj Vijayan]

Is there a way to get the actual numeric value in a formula cell. at the moment if I use, the .CellValue, it returns the Formula String

[Administrator]

Try .FormattedText instead of .CellValue.

[Kirito Tsusaki]

Try .FormattedText instead of .CellValue.

agree

[Sindhu Nagarajan]

Hi Suraj, 

  

Thanks for your update. 

Please let us know if you have any other queries. 

  

Regards, 

Sindhu.