Conversion with to()

Use to() when the expression itself should name the unit you want. Use the result chip when you only want to change how this region displays.

The to() function

The first argument is a quantity. The second is a quoted unit string. Add a trailing = to show the result.

to(1 m, "mm") =
to(25 degC, "degF") =
to(1 Hz, "rpm") =
to(R, "lbf") =

The result stays in that unit even if you switch the worksheet from SI to USCS. Incompatible units produce an error instead of a converted number.

There is no convert() function. Type to like any other built-in; it is not a ribbon button.

The result chip

Click the unit on a result to pick a compatible display unit. That sets a preferred unit on this region only. Right-click and choose Reset units to return to the worksheet system’s default display.

Which to use

• to() — the conversion is part of the calculation. Anyone reading the sheet sees the target unit in the expression.
• Result chip — a display preference for this region. The expression stays as you wrote it.
• Unit system — a sheet-wide display convention. See Unit systems.