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:

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:

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