Convert Function

Convert Function

Did you ever want to convert from one unit to a different one

There is a ready-made excel function called convert, you can convert mass, distance, temperature, area, volume, power , it has 3 parameters, your no , from unit , to unit

=convert (no, from unit, to unit)

For example if I want to convert 300m to foot, simply =convert (300,"m","ft"), units will be shown when you will start to type the function & you can simply choose them

Our parameter 300 is in cell B1, so it will be =convert(B1,"m","ft"), shown below step by step illustration

No alt text provided for this image
No alt text provided for this image
No alt text provided for this image


To view or add a comment, sign in

More articles by Chahine Atallah

  • Protect Specific Ranges in Excel

    Assume you have one Excel file & multiple users are updating this file, but each user has to update his fields/cells…

    1 Comment
  • Excel File Protection

    As followup to my previous article, there are many forms of protection to the workbook/Excel File, like mark document…

  • Protecting your worksheets & Workbooks

    How to protect worksheets properly? first there is a difference between protecting worksheets & protecting workbooks…

  • Custom formatting in excel (few guidlines)

    Do you know about custom formatting in excel, for example positive numbers to be green, negative numbers in red , zeros…

  • Dynamic Arrays (Filter Function)

    Most of our time in excel we use Filter & Sort, but the conventional filter in excel has some limitations , "or"…

  • Pivot Table Tips

    Pivot tables one of the most useful feature in excel , ill share some useful tips which might be beneficial to you…

    1 Comment
  • Aggregate Function

    One of the cool functions in Excel is the aggregate function, actually it includes many functions (19 functions ) in…

  • Counting Blank Cells

    How do you usually count blank cells in excel? i think most use the count blank function, but there is one issue in…

    1 Comment
  • Flash Fill in Excel

    We have Got times when we need to extract specific data from certain columns, usually we do it either by using "split…

    2 Comments
  • The XLOOKUP Function

    Many excel users face a problem when extracting data when using VLOOKUP /HLOOKUP Functions, as these functions have the…

Insights from the community

Others also viewed

Explore topics