Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • LastSunday, LastSaturday Date and Time
  • Excel @ before function names in formulas Excel User tips
  • Progress bar in pure functions CHAR
  • Search across sheets in function ADDRESS
  • Return 12 values in one number AND
  • CountIf limitation COUNTIF
  • Walking Columns ActiveX controls
  • Blank (isempty) VS “” (null string) Excel User tips

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

  • Middle name + 1st name Basic Math
  • Progress bar in pure functions CHAR
  • Dynamic selection list ActiveX controls
  • Cells with additional spaces AND
  • Custom fiscal year calendar (CFlex) Basic Math
  • Skills Grid Conditional Formatting

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
  • Middle name + 1st name Basic Math
  • Skills Grid Conditional Formatting
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • Progress bar in pure functions CHAR
  • OFFSET+MATCH Formulas - combined functions
  • When Excel tells you to go get some life Excel User tips
  • Fixed length ID Formulas - combined functions
  • Filter. Google Sheets function Google Sheets

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme