![如何在 Excel 中批量将一列值添加到另一列值](https://linux22.com/image/1421799/%E5%A6%82%E4%BD%95%E5%9C%A8%20Excel%20%E4%B8%AD%E6%89%B9%E9%87%8F%E5%B0%86%E4%B8%80%E5%88%97%E5%80%BC%E6%B7%BB%E5%8A%A0%E5%88%B0%E5%8F%A6%E4%B8%80%E5%88%97%E5%80%BC.png)
我们有库存和价格列,我们想将库存编号添加到价格列
例如。
库存(列) 5
价格(列) 100
我们希望它如下所示
价格(栏)5-100
因此价格的最终值应为 5-100
答案1
要获得总额,请单击价格单元格,然后:
Callout 1 On the Home tab, click the Sum button in the Editing group.
Callout 2 A color marquee surrounds the cells in the formula, and the formula appears in price cell.
Callout 3 Press ENTER to display the result in price cell .
Callout 4 Click in price cell to display the formula in the formula bar.
Callout 5 Write there =SUM(Stock cell number,-(Price cell number))