Operations on a Range application of Optipe Data Tools Suite performs calculations and operations around an Excel cell range simultaneously.

Use this application to:

• Set budgets quickly.
• Modify quotes.
• Prepare data for further calculations.

Features:

• Add, subtract, multiply or divide all cells in a range with a value.
• Apply a custom formula to the cell range.
• Invest values​​.
• Round to integer, ten, hundred, thousand, to one or two decimal places.
• Allows transform formulas to value after calculation.

Examples:

Video Example. Round values in a cell range.

Video Example. Adjust the range values by a factor.

Video Example. Adjust by a factor and round in one step.

Video Example. Reverse range values.

Video Example. Change the cells with a custom formula.

Video Example. Adjust the range values by a factor located in a cell.