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.
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.
- 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.
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.
- 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 is as another cool way to put the result of a formula in another cell.
- 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.
- 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.
- 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.
For further expertise, you can practice here.
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.
- 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)