本文介绍了相同的电子表格,相同的单元格,但结果不同,用户不同的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

从今天开始,我在使用Google表格时遇到了问题.我用来从其他工作表(在同一电子表格中)获取金额的电子表格.

I have a problem with Google sheets since today.The spreadsheet I use to get an amount from a different sheet (within the same spreadsheet).

但是同一张纸会根据用户是谁给出不同的结果.

But the same sheet gives different results depending on who is the user.

在此图像的示例中,对于user A,它是Cell J5,它是€ -50,00,对于user B,它是€ -5000,00似乎与value()有关(这是我在Twitter上看到的,因为从今天开始,许多人都遭受这个问题的困扰)

In the example in this image it's Cell J5 for user A it is € -50,00 but for user B it is € -5000,00It seems something to do with value() (it's what I saw on twitter, as many people suffer from this problem since today)

一旦使用了它们的功能值. (将文本转换为数字),具体取决于用户.

Once their function value is used. (To convert text to a number) It goes wrong depending on the user.

但是我无法确定用户A和用户B中的设置之间的区别

But I can not find out a difference between settings in user A and user B

我的问题是:

是否有人已经知道如何解决此问题(从今天开始似乎已经发生)

Does anyone already know how to solve this issue (which seems to occur since today)

推荐答案

  • 美国语法:
    • =VALUE(1.1) = 1.1
    • =VALUE(1,1) = #N/A #VALUE!
      • US syntax:
        • =VALUE(1.1) = 1.1
        • =VALUE(1,1) = #N/A or #VALUE!
          • =VALUE(1,1) = 1,1
          • =VALUE(1.1) = #N/A #VALUE!

          要查找的两个电子表格之间的区别是区域设置:

          这篇关于相同的电子表格,相同的单元格,但结果不同,用户不同的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-24 08:54