Easily Apply Mathematical Operations without Formula in Excel 2007/2010

We generally use formulas for some common operations in Excel, but using formula in Excel is complex. Kutools for Excel’s Operation tools allows you to easily change values in cells without using formulas.

For example, if you want to increase all product prices up 12%, you can quickly change these values in cells without using formula by applying Kutools for Excel’s Operation tools. With this tool, you just need to select all the product prices cells and make them multiplied by 12%. And you will have the results without using a formula. Demo

You can apply any of the following mathematical operations to each cell in a range:

Addition: Plus a specified operand.
Subtraction: Subtract specified operand.
Multiplication: Each value of cells multiplied by the operand.
Division: Each value of cells divided by the operand.
Exponentiation: Each value of cell power the operand.
Rounding: Round each value of cell to the decimal numbers (specified operand).
Function: Applies a function to each value of cell.
Custom: Create a formula-like expression and apply to each value of cell.

Operand is the value used in the mathematical operation, which can be a simple value, an expression, a single cell reference, a name defined for a single cell.

Click "Kutools">>"Operation">>"Operation tools ". See screenshots (Fig. 1 and Fig.2).


Fig. 1 Operation tools		Fig. 2 Operation tools dialogue box

Usage:

Use the to select the range that you want to apply operation;
Select the operation option from the Operation list box;
Input the operand into the blank area below Operand;
Click OK.

Notes:

If Create formulas option is checked, the results will be in the form of formulas for each cell.
If Skip formula cells option is checked, the operation will skip and automatically ignore the formula cells in the range.
You can press Undo (Ctrl+Z) to restore this operation immediately.

See Operation tools feature demo (video 1)

Video 1.Operation tools feature demo.