SUM(a;b;c...) 分号在Excel中代表什么 [英] What does SUM(a;b;c...) semicolon stand for in Excel

问题描述

比如Excel函数中的SUM(A1:T1; W1:Z1)，这和SUM(A1:T1, W1:Z1)有什么区别.'，' 和 ';'可以在这个 sum 函数中交换吗?

For example, SUM(A1:T1; W1:Z1) in Excel function , what's the difference between this,SUM(A1:T1, W1:Z1). ',' and ';' could be exchangeable in this sum function?

推荐答案

在此上下文中使用逗号或分号取决于您的区域设置.在逗号用作小数点的国家/地区，分号代替了逗号作为参数分隔符的功能.他们的意思是一样的.但您可能会发现，根据 Windows 区域设置，您的 SUM 公式仅适用于一种或另一种.

The use of a comma or semi-colon in this context depends on your regional settings. In countries where a comma is used as the decimal point, a semi-colon replaces the function of a comma-as-parameter-separator. They mean the same thing. But you will probably find that your SUM formula will only work with one or other, depending on the Windows regional settings.

这篇关于SUM(a;b;c...) 分号在Excel中代表什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！