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.

Excel Putting Result of a Formula in Another Cell


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.

Excel Putting Result of a Formula in Another Cell


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.

Excel Putting Result of a Formula in Another Cell

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

Excel Putting Result of a Formula in Another Cell

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


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

Excel Putting Result of a Formula in Another Cell

  • 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).

Excel Putting Result of a Formula in Another Cell

  • Now, Right-click on the mouse.
  • Select Paste Value from the available options.

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

Excel Putting 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.

Excel Putting Result of a Formula in Another Cell

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

Excel Putting Result of a Formula in Another Cell


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

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

Leave a reply

ExcelDemy
Logo