将值添加到单元格中的值

Is there any formula that could be written to add a value to the value in a cell?

有没有可以编写的公式来为单元格中的值添加值?

For Example: cell A:1 has the value 5. Now I want to have some formula in cell A:1 to add '3' to the value in the cell. The cell's value should now be '8'.

例如:单元格A:1的值为5.现在我想在单元格A中使用一些公式:1将“3”添加到单元格中的值。单元格的值现在应为“8”。

And how about a formula across an entire column? For Example: add '3' to the values in column B.

整个专栏中的公式怎么样?例如:将“3”添加到B列中的值。

Any way this can be done either with some formula or script?

有什么方法可以用一些公式或脚本来完成?

Thanks a lot, Yon

非常感谢,Yon

1 个解决方案

#1

Here you can see the solution very well explained: http://www.contextures.com/exceladdnumbertocells.html

在这里你可以很好地解释解决方案:http://www.contextures.com/exceladdnumbertocells.html

Tip: google a little bit

提示:谷歌一点点