DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Fetch Values From Cells for Calculation in Excel Office 365!!

In this article, we are going to see how to Fetch Values From Cells for Calculation and Insert Result into Cells in Excel Office 365 using Kutools. Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Note: kutools for Excel has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

Fetch Values from Cells for Calculation and Insert Result into Cells:

If you want to fetch a value from the cell for calculation and insert the result into the specific cell in the spreadsheet, you need to do the below steps.

  • You need to open the workbook where you want to perform the calculations.
  • On the Kutools Tab, select the More option, choose the Calculator option from the drop-down list.

Select the Calculator option
Select the Calculator option

  • It will open the Kutools Calculator Dialog box.
  • Now, you need to select a cell that contains the value you want to use for the calculation and fetch that value into the calculator by clicking the Get button.
  • Then, select an operator ( +, -, *, /, and so on ) as you need from the calculator.
  • Now, select a second value and click the Get button.
  • You can be able to see the formula at the bottom of your calculator.

Fetch input values
Fetch input values

  • Click the “ = ” ( equal to ) sign to calculate the result and select any cell to display the result and hit the Paste button to insert the output value to that cell.

Result
Result

Verdict:

In the above article, you can clearly learn the steps to Fetch Values From Cells for Calculation and Insert Result into Cells in Excel Office 365 using Kutools. Leave your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!

Keep Reading:

Top comments (0)