Conversion with to()

One line of a sheet has to come out in a particular unit: a reaction in lbf for a US supplier, a shaft speed in rpm, a temperature in degF. Use to() when the conversion belongs in the calculation and should be visible to whoever reads the printed sheet. Use the answer chip when it is only a display preference for that region.

The to() function

to() takes two arguments: a quantity, then a quoted unit string. Add a trailing = to print the converted answer.

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

Because the target unit is written into the expression, the answer stays in that unit even after someone switches the sheet from SI to USCS. Ask for a conversion that does not make dimensional sense and you get an error rather than a number. Passing something with no units at all reports to() requires a quantity with units.

Two practical notes. There is no convert() function. The name is to, typed like any other built-in. And to() has no ribbon button, so you will not find it under Functions ▾.

The result chip

Click the unit on any answer and pick a compatible one from the list. That sets a preferred unit on this region alone, leaving the expression exactly as you wrote it. Right-click and choose Reset units to clear the pin and let the chip follow the worksheet system's default display again.

Choosing between the three

Approach	Scope	Reach for it when
to()	One expression	The conversion is part of the calculation and should survive printing, sharing, and a change of unit system.
Result chip	One region's display	You want this line in different units without touching the maths.
Unit system	The whole worksheet	The entire sheet should read in SI, USCS, or CGS.

Next, preferred unit if you only want to pin a display unit on one chip.