ChangeUnits
Convert Units Your Way

Home  |    Excel Add-In  |    Excel Functions  |    Download


Excel Add-In Features


  • Single function call converts between any combination of units.
  • Recognizes a HUGE number of units including both standard English and metric.
  • Flexible, intuitive syntax ("ft / s^2" or "feet / sec / sec" or "feet / sec – s").
  • Seamlessly integrates with Excel.
  • Converted values are automatically updated `on-the-fly`.
  • Windows and Mac OS X compatible.
  • Easy to install.

To demonstrate the ChangeUnits for Excel add-in, here we set up a spreadsheet to convert a flow rate of 1.0 (cell A1) m^3/s (cell B1) to units of ft^3/min (cell B2).

We start by putting the cursor in cell A2 and clicking the insert function button fx. (In Office 2007, select Formulas from the Ribbon menu to see the insert function button). This brings up the Excel function dialog box. Select the "ChangeUnits" category and a list of the available functions is given.

Selecting the ChangeUnits function and clicking OK starts the ChangeUnits function wizard.

For the "Val" option we enter the value to be converted (cell A1). The input units (cell B1) are entered in the "InUnits" box. And the units to convert to (cell B2) are entered in the "OutUnits" box. Click OK and the converted value appears.

As with any Excel function, the conversion is automatically updated when the data changes. For example, changing the units to convert to (cell B2) to "gal/hr" (gallons per hour), the updated conversion automatically appears in cell B1.





forex . Winter reifen