Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Comments versus Notes Excel User tips
  • Sort list dynamically (functions) COLUMN
  • Return 12 values in one number AND
  • CHOOSE – tree of decisions CHOOSE
  • iframe in Excel (XLiFrame) ADDRESS
  • Looplist – Repeating months using formulas Basic Math
  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • CountIf limitation COUNTIF

CONVERT function

Posted on September 26, 2016 By ANmar

Excel 2010 has a lot of new exciting things, one of them is the ‘Engineering’ category of functions, this was usually a plugin we have to add to get, but in Excel 2010, it is already there.

The function ‘Convert’ does what you expect it, converts a number from one metric to another.

Of course, we cannot remember all metric systems and units, so just press F1, or click help to see this list to know how you can convert from one unit to another in any of the systems inside that function

The one I most interested is

=Convert( 45, "mi", "km")

convert5

More images …

convert5 convert4 convert3 convert2

 

CONVERT, Engineering, Standard functions

Post navigation

Previous Post: Hello world!
Next Post: VLookup

Related Posts

  • Scorring, saving multiple outputs in 1 number Basic Math
  • Skills Grid Conditional Formatting
  • LastSunday, LastSaturday Date and Time
  • Fx to cut long column into two columns Formulas - combined functions
  • Sort list dynamically (functions) COLUMN
  • Search across sheets in function ADDRESS

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (83)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (6)
      • Average (1)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • When Excel functions are not enough Excel User tips
  • Standard math to calculate Aspect Ratio Basic Math
  • Filter. Google Sheets function Google Sheets
  • Return 12 values in one number AND
  • Searching table in 2 dimensions. Formulas - combined functions
  • Schedule column Basic Math
  • Progress bar in pure functions CHAR
  • Formula Beautifier Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme