Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

importxml formula in Google Sheets adds random cell below it

I want to fetch the bitcoin price through the formula importxml, which it works.

The problem is that it adds a random value to the cell below it. I can’t delete it.

This is the formula

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

=IMPORTXML("https://coinmarketcap.com/currencies/"&D1, "//div[contains(@class, 'priceValue')]")

This is the result (what’s that number (0.0668) there?):

enter image description here

>Solution :

Can you try this:

=IMPORTXML("https://coinmarketcap.com/currencies/"&D1,"//div[@class='priceValue ']")

enter image description here

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading