如何在Excel中將一列值批次新增到另一列值

如何在Excel中將一列值批次新增到另一列值

我們有庫存和價格列,我們想將庫存號碼新增到價格列

例如。

庫存(欄) 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))

檢查此參考

相關內容