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

### 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. ### 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 #### Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts 