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**.

**Table of Contents**hide

## Download Practice Workbook

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

### 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.

### 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 is as another cool way to **put the result of a formula in another cell**.

**Read More:** **How to Return Value of Cell Not Formula in Excel (3 Easy Methods)**

**Similar Readings**

**How to Convert Formulas to Values in Excel (8 Quick Methods)****Convert Formula to Value in Multiple Cells in Excel (5 Effective Ways)****How to Stop Formula to Convert into Value Automatically in Excel****Convert Formula to Value Without Paste Special in Excel (5 Easy Methods)**

### 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 need.

**Read More:** **How to Show Value Instead of Formula in Excel (7 Methods)**

### 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.

## Practice Section

For further expertise, you can practice here.

## 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. For any further questions, comment below. For more information regarding Excel, you can visit our **ExcelDemy **site.

## Related Articles

**How to Convert Formula to Value Automatically in Excel (6 Effective Ways)****VBA to Remove Formulas in Excel Keeping Values and Formatting****How to Convert Formula Result to Text String in Excel (7 Easy Ways)****Excel VBA: Convert Formula to Value Automatically (2 Easy Methods)****How to Remove Formula in Excel and Keep Values (5 Ways)**