Have you ever needed to apply the same mathematical operation to many cells in an Excel spreadsheet? The Range Calculations add-in changes automatically the values of several cells at the same time. This way you can perform calculations with a pre-aggregated value on multiple selected cells and with a single click. The tool lets you add, divide, multiply and subtract, among other options, the values of the cells individually or in batch (on the selected ones).
Installing Range Calculations
Its installation is very simple. First, go to the official Office Store and sign in. Then add Range Calculations, open an Excel document, click on Insert and then on My Apps, and select Range Calculations. Doing this, you will see the tool on the right side of the Excel document and you will be able to choose between subtraction, multiplication, division, calculate percentage, add percentage, subtract percentage, and add.
How to Use Range Calculations
Now you just have to select the cells of the spreadsheet, enter a numeric value in Enter a number, select an action and click on Calculate. At that moment the platform will start doing its work.
A Free and Useful Add-in
Range Calculations is a very good add-in for performing mathematical calculations on several cells at the same time with the same predetermined value. You only need a few clicks for the tool to perform the action individually on each cell. In our tests we multiplied several cells with different values by eight and it performed the multiplication quickly and accurately. Range Calculations is a free add-in for Microsoft Office Excel spreadsheets.
https://old.neoteo.com/como-generar-tablas-dinamicas-en-linea-para-excel/
