Text Operations | Numeric Operations | Date Operations
Spreadspeed offers the following tools to perform numeric operations on a range of cells.
The Fill Random Values tool can fill a selected range with random numbers using either a uniform or normal distribution, with options to set the minimum value, maximum value, and the numbers of digits of precision. Note: The normal (Guassian) distribution values are generated using a Box-Muller algorithm.
This tool lets you perform a variety of mathemical operations on a selected range, updating the values in place.
Available Math Operations | ||
---|---|---|
Absolute value | Floor | Round |
Acos | Inverse | Sin |
Add | Log | Sinh |
Asin | Log10 | Sqrt |
Atan | Max | Subtract |
Ceiling | Min | Tan |
Cos | Modulo | Tanh |
Cosh | Multiply | Toggle Sign |
Divide | Negative Value | Truncate |
Exp | Pow |
The image below shows the Change Numeric Values dialog. After selecting a Function, the description field is updated to describe the operation and, if required, the Parameter field is enabled and re-labeled with the parameter name.
Text Operations | Numeric Operations | Date Operations