The CONVERT function transforms a number from one measurement system to another - for example, miles to kilometers, pounds to kilograms, Fahrenheit to Celsius, or gallons to liters. It supports many unit categories including distance, weight, temperature, volume, and more. The function requires the value, the from_unit, and the to_unit as parameters.