Description:
The Cell Math add-in provides an easy way to modify cells without using formulas. Some of the functionality of Cell Math is available through Excel's Paste Special command (with the Add, Subtract, Multiply, or Divide option), but Cell Math is much more versatile and easier to use.
Features:
- Perform common mathematical operations: addition, subtraction, multiplication, division. For example, you can use Cell Math to increase all cells by 5% (see the figure above).
- Input the operand manually, or use the value in a cell or named cell.
- Perform exponentiation (not possible with Paste Special)
- Apply rounding to cells (for example, round the values in all cells to two decimal places).
- Apply an Excel function (such as SIN or SQRT) to each value in a range.
- Use the Custom option to apply any mathematical operation that can be expressed as an Excel formula.
- As an option, create formulas from the value cells.
- As an option, perform the operation on existing formula cells (the formulas are modified accordingly).
- Your dialog box settings are saved and recalled automatically, making it easy to apply the same operation to multiple ranges.
- A progress bar displays the progress of the operation.
- The results of the mathematical operations can be undone.
Pricing:
The Cell Math add-in is free. No strings attached. No nag messages. No
time limit. This add-in requires Excel 97 or Excel 2000, and it will not work with Excel 5 or Excel
95.
Installation:
- Download the J-Walk Cell Math add-in (180K). It's a self-extracting EXE file.
- Double-click the cellmath.exe file. You can then extract the cellmath.xla add-in file to a directory of your choice.
- Start Excel and select the Tools - Add-Ins command.
- In the Add-Ins dialog box, click the Browse button and locate cellmath.xla (the file you extracted in Step #2).
- Click OK
- Activate your workbook.
- Select Tools - J-Walk Cell Math from the menu.