Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • CountIf limitation COUNTIF
  • Links between two workbooks – dynamically using functions INDIRECT
  • Min Max vehicle Formulas - combined functions
  • Custom fiscal year calendar (CFlex) Basic Math
  • New function IFERROR, finally IFERROR
  • Show developer tab Excel User tips
  • Count how many times letter found Formulas - combined functions
  • CHOOSE – tree of decisions CHOOSE

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

  • Zipcode-State search Formulas - combined functions
  • Standard math to calculate Aspect Ratio Basic Math
  • Skills Grid Conditional Formatting
  • CountIf limitation COUNTIF
  • Min Max vehicle Formulas - combined functions
  • Sheet() and Sheets() Lookup and References

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
  • Excel Dynamic Drop-Downs that grow with you COUNTA
  • Zipcode-State search Formulas - combined functions
  • Middle name + 1st name Basic Math
  • LastSunday, LastSaturday Date and Time
  • Pixel Excel Drawing Format Cells
  • Stale values (Scratched functions) Excel User tips
  • Calculate hours between two cells ABS
  • Convert cell into textbox Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme