CONVERT in WPS Spreadsheet: Convert Temperatures with Exact Unit Labels

=CONVERT(20,"C","F") converts 20 degrees Celsius to an independently expected 68 degrees Fahrenheit. Use quoted unit codes rather than full unit names. The WPS unit table explicitly lists C, F and K for these three temperature scales.

CONVERT(number,from_unit,to_unit)

All three arguments are supplied: the numeric measurement, its source unit and the required result unit. There are no optional arguments in this syntax. Unit names and prefixes are case-sensitive. These examples use only the three verified temperature codes; they do not infer support for arbitrary abbreviations or prefixes.

Enter the following in an empty sheet:

In B2 enter =CONVERT(A2,"C","F") and fill down through B4. In C2 enter =CONVERT(A2,"C","K") and fill down through C4. Keep units in headers so the output cells remain numbers.

These controls follow F = C × 9/5 + 32 and K = C + 273.15. A temperature conversion includes an offset: multiplying Celsius by a single factor cannot produce Fahrenheit correctly.

In D2 enter =CONVERT(B2,"F","C"); the expected result is 20. Fill through D4 to recover 0 and 100. Small final-digit differences can arise from numerical precision, so compare using a reasonable tolerance rather than displayed digits alone.

A temperature reading and a temperature difference are distinct quantities. A rise from 10°C to 20°C is a 10°C difference but an 18°F difference. Converting the endpoints gives 50°F and 68°F; subtract them. Applying =CONVERT(10,"C","F") to the difference would give 50, which answers the wrong question. Likewise, for scientific interpretation, absolute temperature and an offset scale must not be mixed in ratios.

• A recognized unit from a different measurement group is not interchangeable with a temperature unit. The lesson documents #N/A for incompatible groups, unknown units and unsupported prefixes.
• Check the exact case of the quoted text. Avoid accidental spaces or typographic lookalikes.
• The lesson mentions #VALUE! for invalid input data. It does not establish a complete coercion contract; keep the measurement numeric.
• The lesson’s pound walkthrough contains an ambiguous I/l spelling. This guide deliberately uses visually verified temperature labels instead of reproducing that ambiguity.
• Do not assume the function validates physically possible temperatures. The reviewed material does not document an absolute-zero validation rule.

The examples convert readings, not measurement uncertainty or equipment calibration. Keep the original reading, original unit and required reporting precision in the worksheet. See ROUND when the reporting calculation requires an explicitly rounded value rather than a display-only number format.

The official WPS CONVERT lesson was checked on October 19, 2026. Its edition banner identifies WPS Office for Windows Personal. It does not establish an exact minimum build, English-global availability or support on Mac, Linux, web and mobile. The calculations above are independent expected results, not observed WPS outputs. Native execution and genuine current-application screenshots remain unverified.

Browse the WPS function library.