Apply additional calculations to selected cells

Number > Add extra calculation to selected cells

With this utility, you can quickly perform calculations on all selected cells at once.

For example, quickly multiply all selected cells by 10 without having to add an extra column and enter a formula for it.

The formula will be built around the original formula or value in your cell. For example, if you have original_formula «=(3.14*10)» in a cell, and you use YLC Utilities to apply an additional calculation "initial_formula/60" , the result will be: «=(3.14*10)/60» .

The formula will be applied to all cells in your selection except cells with errors, empty cells, cells containing text, or cells that contain an array formula.

If the new formula results in an error, you will receive a warning and no changes will be applied.

There are many variations of formulas that can be entered, for example, «/100», «+9», «*2,718», «*G4» .

This utility is also often used for unit conversions, such as converting kilometers to meters.

Screenshot

After application:

Running this tool

Click YLC Utilities > Number > Add extra calculation to selected cells :

Do you recognize any of these situations?

• How can I quickly multiply all selected cells by 100 without having to add an extra column and enter a formula for it?
• I have a column with values in currencies. I would like to convert these values to another currency by dividing or multiplying by the exchange rate.
• Is there a way to quickly update the price list at the end of the year by increasing prices by 10%?

How much time will this save?

Using this tool will definitely save you time and effort. However, the actual time savings will depend on how often you use it. LO Calc , the amount of data you work with, and how often you use this tool.

Download extension

You can use the utility Add extra calculation to selected cells by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in LibreOffice Calc .