Forum Discussion
Unable to take the htmlpage value for formula
Unable to use the htmlpage value for formula
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.
3 Replies
That's Google Sheets question, isn't it?
yes, that for google sheets.
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.
