在Google Spreadsheet中划分整列 [英] Dividing whole column in Google Spreadsheet

问题描述

我是Google Spreadsheet的较新用户.

我希望«B»列中的每个单元格都是«A»列(在同一行中)除以5的结果.

B1，B2，B3等(商)应为A1，A2，A3等(除数)除以5(除数).

例如: B1 =(A1)/5 .

我知道一个接一个的公式是将 = DIVIDE(A1,5)放置在B1单元格中，并放置 = DIVIDE(A2,5)等，但这就像手动计算每个单元格一样复杂.

目标是在[ B [*相同行号*] 中自动填写( A [*相同行号*]/5 )的商>)列.

但是我应该将[相同行号]的要求翻译/替换为Google Spreadsheets可以理解的语言或公式，因为我猜想有一个公式?

解决方案

您要查找的单词称为

当我将第一个单元格拖到末尾时，这就是google电子表格所做的

带有值的结果

I'm a relatively new user to Google Spreadsheet.

I'd like every cell in the «B» column to be the result of what's in the «A» column (in the same row) but divided by 5.

B1, B2, B3, etc. (the quotients) should be A1, A2, A3, etc. (the dividents) divided by 5 (the divisor).

In example: B1 = (A1)/5.

I know the formula for doing it one by one is placing i.e. =DIVIDE(A1,5) in the B1 cell, and to place =DIVIDE(A2,5) in the B2 cell, etc. — but this would be as complicated as calculating every cell manually.

The goal is to automatically fill in the quotient of the (A[*same row number*]/5) in the (B[*same row number*]) column.

But how do I translate/replace what I call for [same row number] to the language or formula that Google Spreadsheets understands, because I guess there is a formula for this?

解决方案

The word you are looking for is called cell reference in Excel or spreadsheet lingo.

Use the formula =DIVIDE($A1,5) and drag the cell handle down across all the cells. Here is my sample.

When I dragged the first cell to the end, this is what google spreadsheet did

Result with values

这篇关于在Google Spreadsheet中划分整列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！