It is a very common phenomenon that we need to put the result of a formula in different places on the worksheet. We can do it quite easily just by following some simple methods. In this article, I will explain 4 simple cases (methods) of putting the result of a formula in another cell in Excel.

For more clarification, I am going to use a Dataset containing Employee Name, Department, and Salary columns. In cell D9, I have input **SUM Function**Â to find out the summation of cells **D5:D8**.

## Putting Result of a Formula in Another Cell in Excel: 4 Basic Cases

### 1. Putting Formula Result in Another Cell Mentioning Cell Reference

It is the simplest way possible to put the result of a formula in another cell. You need to follow the following steps to do it perfectly.

**Steps**:

- Select a cell to put the result of a formula (i.e.
**D12**). - Input the following formula:

`=D9`

Here, I mentioned the **D9 **cell, which contains a formula, to have the result along with its formula in cell **D12**.

- Press
**ENTER**to have the desired result.

**Read More: **Convert Formula to Value Without Paste Special in Excel

### 2. Applying Define Name Command to Transfer Formula Result

We can put the result of a formula in another cell by applying the **Define Name **command. It is also a very effective and time consuming way.

**Steps**:

- Select the
**FormulasÂ**tab. - Then, go to
**Define Name**from the ribbon.

The **New Name **box will appear.

- Input a suitable name in the
**Name**section (i.e.**Total_Salary**). - Set the cell of a worksheet from where you want to duplicate the result of a formula (i.e.
**D9**from the**Define Name**worksheet). - Next, press
**OK**.

- Now, go to the cell where you want to have the result with the formula (i.e.
**D12**). - Write the following formula in that cell:

`=Total_Salary`

Here, I mentioned the defined name **Total_Salary **which will return the defined result with the formula.

- Finally, hit
**ENTER**button and finish the process.

Thatâ€™s it. The formula result is in another cell. I believe you have found this to be another cool way to put the result of a formula in another cell.

**Read More: **Excel VBA: Convert Formula to Value Automatically

### 3. Applying Paste Values to Put Result of a Formula

**Paste Values **is another easy method to put the result of a formula in another cell. You just need to follow the following steps.

**Steps**:

- Select the cell the result of which you want to put in another cell (i.e.
**D9**).

- Right-click on the mouse and click on
**Copy**.

Alternatively, you can press **CTRL + C **to **Copy **the result.

- Next, pick a cell where you want to put the result (i.e.
**D12**).

- Now, right-click on the mouse.
- Select
**Paste Value**from the available options.

Finally, we have the result of a formula in another cell.

You can modify the result according to your needs.

**Read More: **How to Convert Formula Result to Text String in Excel

### 4. VBA Code to Put Result of a Formula in Another Cell

The smartest way to put the result of a formula in another cell in Excel is the employment of **VBA**. We are gonna describe the whole procedure in the following section.

**Steps**:

- Choose the
**DeveloperÂ**tab. - Then, pick
**Visual Basic**from the ribbon.

- Next, click on
**Insert**. - From the available options, select
**Module**.

- Followingly, write the following
**Code**:

```
Sub PutResult()
Â Â Â ActiveSheet.Range("D12").Value = ActiveSheet.Range("D9").Value
End Sub
```

Here, I have mentioned a *Sub Procedure *named **PutResult**. I have mentioned the following worksheet to return the result of the **D9 **cell in cell **D12 **with the formula.

- Next, press the
**RUN**button to apply the code.

Finally, we will see the output on the mentioned cell with the result along with the formula.

**Read More: **How to Return Value of Cell Not Formula in Excel

## Practice Section

For further expertise, you can practice here.

**Download Practice Workbook**

## Conclusion

In this article, I have tried to articulate 4 simple methods for putting the result of a formula in another cell in Excel. I hope it will be helpful for all.

## Related Articles

- How to Stop Formula to Convert into Value Automatically in Excel
- Convert Formula to Value in Multiple Cells in Excel
- How to Convert Formula to Value Automatically in ExcelÂ

**<< Go Back to Convert Formula to Value in Excel | Excel Formulas | Learn Excel**