What is the translation of " 单元格引用 " in English?

• cell reference
• cell references

Examples of using 单元格引用 in Chinese and their translations into English

使用相对或绝对单元格引用.
Make use of relative and absolute cell references.

原因：默认单元格引用样式(A1)，它是指为字母的列，为数字行是指，已更改。
Cause: The default cell reference style(A1), which refers to columns as letters and refers to rows as numbers, was changed.

使用单元格引用的好处是如果单元格中的数字更改，ExcelOnline会自动更新公式结果。
The advantage of using cell references is that if the numbers in the cells change, Excel Online automatically updates the formula result.

结果是单元格B2中给出的单元格引用的绝对值，即等于6。
The result is the absolute value of the cell reference specified in B2, which in this case is 6.

Excel将自动调整单元格引用，以便包括各行的正确值。
Excel adjusts the cell references automatically to include the correct values for each row.

此参数可以是单元格引用，也可以是固定值，如"smith"或21000。
This argument can be a cell reference, or a fixed value such as"smith" or 21,000.

由于单元格引用位于括号内，首先从销售价格中减去已售货物的成本。
Because the cell references are in parentheses, first the cost of goods sold is subtracted from the sales price.

这可以是单元格引用，也可以是“smith”或21,000之类的硬编码值。
This argument can be a cell reference, or a fixed value such as"smith" or 21,000.

DAYS函数的两个参数可以是实际日期、单元格引用或其他日期和时间函数,如TODAY函数。
The two arguments of the DAYS function can be actual dates, cell references, or another date and time function- such as the TODAY function.

单元格引用是列字母和行号的结合，如A1或F345。
A cell reference combines the column letter and row number, such as A1 or F345.

您可在PRODUCT函数中使用由最多255个数字或单元格引用构成的任何组合。
You can use any combination of up to 255 numbers or cell references in the PRODUCT function.

形式为数字、表达式、单元格引用或文本的1至127个条件，用来定义将计算平均值的单元格。
There can be 1 to 127 criteria in the form of a number, expression, cell reference, or text that define which cells will be averaged.

如果您将公式复制到其他单元格，则需要使用绝对单元格引用（注意$符号），如下所示：.
If you're going to copy your formula to other cells, you need to use absolute cell references(note the$ signs), like this.

但将公式向列B下复制将不起作用，因为单元格引用C2更改为C3、C4等等。
But copying the formula down column B won't work, because the cell reference C2 changes to C3, C4, and so on.

观看此视频可了解如何使用多个运算符、单元格引用和函数创建更复杂的公式。
Watch this video to learn how to create more complex formulas using multiple operators, cell references, and functions.

第一个参数可以是具体值（如“41”或“Smith”），也可以是单元格引用，如“F2”。
Your first argument can be a specific value like"41" or"smith," or it can be a cell reference, like F2.

Index_num必须是介于1到254之间的数字，或是包含1到254之间的数字的公式或单元格引用。
Index_num must be a number between 1 and 254, or a cell reference with values between 1 and 254.

Note:Inalloftheseformulas,无论它说“文本”在哪里也可以使用单元格引用）.
(Note: In all of these formulas, wherever it says“text” you can use a cell reference as well).

绝对引用是指单元格引用不会随着公式所在单元格位置的变更而改变。
An absolute reference means that the referenced cell will not change when you change the position of the cell with the formula.

可以链接到工作簿中的不同位置，如单元格引用或已定义名称。
You can link to different places in a workbook, such as a cell reference, or defined name.

检查是否存在包含公式的单元格引用，然后返回TRUE或FALSE。
Checks whether there is a reference to a cell that contains a formula, and returns TRUE or FALSE.

Index_num必须是介于1到254之间的数字，或是包含1到254之间的数字的公式或单元格引用。
The argument index_number must be a number between 1 and 254, or a formula or reference to a cell containing a number between 1 and 254.

包含相对单元格引用的公式会因为你将它从一个单元格复制到另一个而发生改变。
A formula that contains a relative cell reference changes as you copy it from one cell to another.

细胞可引用其他单元格计算结果值。
Cells may reference other cells to compute a value.

例如，如果将单元格B2中的绝对引用复制到单元格B3，则在两个单元格中一样，都是$A$1。
For example, if you copy or fill an absolute reference in cell B2 to cell B3, it stays the same in both cells =$A$1.

如果想要返回对指定单元格的引用，请参阅引用形式。
If you want to return a reference to specified cells, see Reference form.

如果包含公式的单元格的位置改变，绝对引用仍保持不变。
If the position of the cell that contains the formula changes, the absolute reference remains the same.

Array1和array2可以是单元格区域、数组常数或引用。
Array1 and Array2 can be given as cell ranges, array constants, or references.

其他时候你不希望更改对其他单元格的引用。
Other times, you may not want the references to other cells to change.

当公式引用的单元格包含N/A时，公式返回错误值N/A。
(When a formula refers to a cell containing N/A, the formula returns the N/A error value.).