Optipe Data Tools Suite - Operations on Range
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.