# Putting Result of a Formula in Another Cell in Excel (4 Common Cases)

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.

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

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

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

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

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

Get FREE Advanced Excel Exercises with Solutions!
Naimul Hasan Arif

Naimul Hasan Arif, a BUET graduate in Naval Architecture and Marine Engineering, has been contributing to the ExcelDemy project for nearly two years. Currently serving as an Excel and VBA Content Developer, Arif has written more than 120 articles and has also provided user support through comments His expertise lies in Microsoft Office Suite, VBA and he thrives on learning new aspects of data analysis. Arif's dedication to the ExcelDemy project is reflected in his consistent contributions and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF