Search This Blog

pCloud Crypto

CONVERT formula in Excel with examples

The CONVERT function in Excel allows you to convert a value from one measurement system to another. Here’s how it works:

  1. Syntax:

    CONVERT(number, from_unit, to_unit)
    
    • number: The value you want to convert.
    • from_unit: The units for the input value.
    • to_unit: The units for the result.
  2. Measurement Systems: The CONVERT function accepts various text values (in quotation marks) for from_unit and to_unit. These include:

    • Length: "mi" (miles), "km" (kilometers), "yd" (yards), "m" (meters), etc.
    • Temperature: "C" (Celsius), "F" (Fahrenheit), "K" (Kelvin).
    • Mass: "lbm" (pounds), "kg" (kilograms), "ozm" (ounces), etc.
  3. Examples:

    • To convert 1 mile to kilometers: =CONVERT(1, "mi", "km") (result: 1.609 kilometers).
    • To convert 12 inches to centimeters: =CONVERT(12, "in", "cm") (result: 30.48 centimeters).

Remember to adjust the function based on your specific conversion needs!

pCloud Lifetime

The customer care and complaint management contact details for BASIC Bank Limited

If you need to get in touch with  BASIC Bank Limited  in Bangladesh regarding complaints or suggestions, here are the ways you can reach the...