英文:
Google Sheets - results of formula in wrong cell
问题
在谷歌表格中，我创建了一个包含电影清单和与评论链接的表格。
基于这些评论，我想从网站上获取平均百分比，所以我写了一个类似图片中的公式。1
但问题是，这个公式计算出的结果59%也被放到了下一个单元格中，就像这样。2
当我覆盖该单元格以获得两倍的结果时，它看起来像这样。3 之前的结果最终变成了“ref”，并且重复的结果又出现了。
我做错了什么？
我只是想在电影名称旁边的一个单元格中显示百分比，但我真的不知道还能尝试什么。
英文:
In google sheets, i made a table with lists of film and also with link with reviews.
Based on those reviews I wanted to scrap average percentage out of the website so I write a formula like in the picture.1
But problem is that result 59% this formula put also into the next cell like a text. Looks like this.2
When I overwrite that cell with doubled outcome, it looks like this.3 Previous result end up like "ref and situation with doubled outcome is there again.
What I am doing wrong?
I just want to have percentage in one cell next to name of the film, but I really dont know what else to try.
答案1
得分: 0
=importxml(D2;"//aside[1]/div[1]/div[1]/div[1]")
英文:
Can you try:
=importxml(D2;"//aside[1]/div[1]/div[1]/div[1]")
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论