Forum Discussion
SanthoshKumarArutperunjothi10
May 30, 2025Copper Contributor
Unable to take the htmlpage value for formula
Unable to use the htmlpage value for formula
- May 31, 2025
When you are retrieving the value, it is returning as text due currency symbol "₹"
Below formula shall be helpful for you.
=VALUE(SUBSTITUTE(INDEX(IMPORTHTML("https://www.goodreturns.in/gold-rates/bangalore.html","table",1),2,2),"₹",""))If this resolves your query don't forget Mark as Solution.
May 31, 2025
When you are retrieving the value, it is returning as text due currency symbol "₹"
Below formula shall be helpful for you.
=VALUE(SUBSTITUTE(INDEX(IMPORTHTML("https://www.goodreturns.in/gold-rates/bangalore.html","table",1),2,2),"₹",""))
If this resolves your query don't forget Mark as Solution.