ICT Tutorials
  • HOME
  • INTRO & WINDOWS
    • INTRODUCTION >
      • FUNDAMENTAL OF IT
      • TYPE OF COMPUTER DEVICES
      • COMPUTER GENERATION
      • SYSTEM COMPUTER
      • TYPE OF COMPUTERS
      • NUMBERING SYSTEM
      • TYPE OF MOUSE
      • KEYBOARD
      • DATA PROCESSING
      • OPERATING SYSTEM
      • HISTORY OF COMPUTER
    • MS WINDOWS >
      • ABOUT MS WINDOWS
      • WINDOWS DESKTOP
      • Win Control Activation
  • MS OFFICE
    • ABOUT MS-OFFICE
    • MS WORD >
      • INTRO TO MS-WORD
      • FILE >
        • INFO, NEW, OPEN
        • SAVE AND SAVE AS, PRINT
        • SHARE, EXPORT, CLOSE
      • HOME >
        • CUT, COPY, PASTE, FORMAT PAI
        • FONT
        • STYLES
        • FIND, GO TO, REPLACE
      • INSERT >
        • PAGES -COVER, BLANK, BREAK
        • TABLES
        • ILLUSTRATIONS >
          • PICTURES, ONLINE PICTURE
          • SHAPES, ICONS, 3D MODELS
          • SmartArt
          • CHART, SCREENSHOT
        • LINK, BOOKMARK, CROSS-REF
        • COMMENT, HEADER/FOOTER
        • TEXTS >
          • TEXT BOX, WORDART, DROP CAP, OBJECT
        • SYMBOL
      • DRAW >
        • PENS
      • DESIGN >
        • DOC STYLES, WATERMARK
        • PHARAGRAPH
        • PAGE COLOR, BORDERS
      • LAYOUT >
        • PAGE SETUP, SPACING
        • ARRANGE OBJECTS
      • REFERENCES >
        • TABLE OF CONTENTS
      • MAILINGS >
        • ENVELOPES
      • REVIEW >
        • DOC REVIEWS
      • VIEW >
        • WEB LAYOUT, NEW WIN, SPLIT
        • SWITCH WINDOWS, MACROS
    • MS EXCEL >
      • INTRO TO MS-EXCEL
      • FILE >
        • INFO, NEW, OPEN
        • SAVE/SAVE AS, PRINT
        • SHARE, EXPORT
      • HOME >
        • ALIGNMENT >
          • CELL ALIGN, ORIENTATION
          • INDENTS, MERGE & CENTER
        • NUMBER, COND FORMAT
        • TABLE, INSERT, DELETE
        • FORMAT >
          • ROW HEIGHT, COLUMN WIDTH
          • HIDE, RENAME, MOVE OR COPY
        • PROTECT SHEET, FILL
        • SORT & FILTER, AUTOSUM
      • FORMULAS >
        • INTRO TO FORMULAS
        • MATH & TRIM >
          • ABS( ), COMBIN( )
          • SUM FUNCTIONS( )
          • COS( ), SIN( )
          • BASE( )
        • STATISTICAL >
          • AVERAGE FUNCTIONS( )
          • MAX FUNCTIONS( )
          • MIN FUNCTIONS( )
          • COUNT FUNCTIONS( )
          • MODE FUNCTIONS( )
        • ENGINEERING >
          • BIN2DEC
          • CONVERT
        • TEXT FUNCTIONS >
          • LEFT( ) RIGHT( ) MID( )
          • FIND( ) LEN( ) PROPER( )
          • TRIM( ) EXACT( ) FIXED( )
          • REPLACE, UNICHAR, UNICODE
          • CODE( ) CHAR( ) REPT( )
        • DATE & TIME FUNCTIONS >
          • TODAY( ) YEAR( ) DAYS( )
        • LOGICAL >
          • IF( ), IFERROR( )
          • IFS( ), SWITCH( )
          • AND( ), OR( )
          • IFNA( ), XOR( )
      • INSERT >
        • CHARTS, SPARKLINES
      • PAGE LAYOUT >
        • PRINT TITLES, SHEET OPTION
      • DATA >
        • GET DATA, DATA VALIDATION
        • CONSOLIDATE
      • VIEW >
        • WORKBOOK VIEWS
      • Excel Functions Exercises >
        • Exercises 1 and 2
        • Exercises 3 and 4
    • MS POWER POINT >
      • INTRO TO MS-POWERPOINT
      • FILE >
        • INFO, NEW, OPEN
        • SAVE AND SAVE AS, PRINT
        • SHARE, EXPORT, CLOSE
      • HOME >
        • NEW SLIDE, STYLES, FILL
      • INSERT >
        • PHOTO ALBUM, VIDEO, AUDIO
        • SCREEN REC, SHOT, SLIDE NUM
      • DESIGN >
        • THEMES, SLIDESIZE, FORMAT
      • TRANSITION >
        • TRANSITION, SOUND
    • MS ACCESS >
      • INTRO TO MS-ACCESS
      • FILE >
        • HOME, NEW, OPEN
    • OFFICE QUESTION & ANSWER
  • VISUAL STUDIO
    • VISUAL BASIC .NET >
      • INTRODUCTION
      • .NET FRAMEWORK
      • OPERATORS IN VB.NET
      • DATAYPES IN VB.NET
      • VB.NET KEYWORDS
      • VARIABLE AND CONST
      • INTRO TO VB.NET PLATFORM
      • INTRO TO PROGRAMMING
      • OBJECTS USAGE IN WIN-FORM
    • Python >
      • Introduction
    • C++
  • GOOGLE TIPS
    • GMAIL ACCOUNT >
      • Email Forwarding
      • Setting up Authenticator App
      • SIGNATURE SET UP
    • GOOGLE WORKSPACE
  • INVENTS
    • NEW INVENTS
  • ABOUT ME

CONVERT function

13/1/2018

0 Comments

 
CONVERT function:
Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers.

Syntax
CONVERT(number,from_unit,to_unit)​
Number     is the value in from_units to convert.
From_unit     is the units for number.
To_unit     is the units for the result. CONVERT accepts the following text values (in quotation marks) for from_unit and to_unit.
 
I have given here all the from units and to units for using in Excel.
Weight and mass                From_unit or to_unit
Gram                                    "g"
Slug                                      "sg"
Pound mass (avoirdupois)    "lbm"
U (atomic mass unit)           "u"
Ounce mass (avoirdupois)   "ozm"
Grain                                    "grain"
U.S. (short) hundredweight "cwt" or "shweight"
Imperial hundredweight      "uk_cwt" or "lcwt" ("hweight")
Stone                                    "stone"
Ton                                       "ton"
Imperial ton                         "uk_ton" or "LTON" ("brton")

Distance                                   From_unit or to_unit
Meter                                        "m"
Statute mile                              "mi"
Nautical mile                            "Nmi"
Inch                                          "in"
Foot                                          "ft"
Yard                                         "yd"
Angstrom                                 "ang"
Ell                                             "ell"
Light-year                                 "ly"
Parsec                                       "parsec" or "pc"
Pica (1/72 inch)                        "Picapt" or "Pica"
Pica (1/6 inch)                          "pica"
U.S survey mile (statute mile)  "survey_mi"
 
Time    From_unit or to_unit
Year     "yr"
Day      "day" or "d"
Hour     "hr"
Minute  "mn" or "min"
Second "sec" or "s"
            
 Pressure            From_unit or to_unit
Pascal                 "Pa" (or "p")
Atmosphere       "atm" (or "at")
mm of Mercury  "mmHg"
PSI                     "psi"
Torr                    "Torr"
                          
Force           From_unit or to_unit
Newton        "N"
Dyne            "dyn" (or "dy")
Pound force "lbf"
Pond            "pond"

Energy                           From_unit or to_unit
Joule                               "J"
Erg                                  "e"
Thermodynamic calorie  "c"
IT calorie                        "cal"
Electron volt                   "eV" (or "ev")
Horsepower-hour            "HPh" (or "hh")
Watt-hour                       "Wh" (or "wh")
Foot-pound                     "flb"
BTU                                "BTU" (or "btu")

Power          From_unit or to_unit
Horsepower  "HP" (or "h")
Pferdestärke "PS"
Watt             "W" (or "w")

Magnetism From_unit or to_unit
Tesla            "T"
Gauss           "ga"

Temperature        From_unit or to_unit
Degree Celsius       "C" (or "cel")
Degree Fahrenheit  "F" (or "fah")
Kelvin                    "K" (or "kel")
Degrees Rankine    "Rank"
Degrees Réaumur   "Reau"

Volume (or l iquid measure ) From_unit or to_unit
Teaspoon                                   "tsp"
Modern teaspoon                       "tspm"
Tablespoon                                "tbs"
Fluid ounce                                "oz"
Cup                                            "cup"
U.S. pint                                    "pt" (or "us_pt")
U.K. pint                                    "uk_pt"
Quart                                         "qt"
Imperial quart (U.K.)                "uk_qt"
Gallon                                        "gal"
Imperial gallon (U.K.)               "uk_gal"
Liter                                           "l" or "L" ("lt")
Cubic angstrom                         "ang3" or "ang^3"
U.S. oil barrel                            "barrel"
U.S. bushel                                "bushel"
Cubic feet                                  "ft3" or "ft^3"
Cubic inch                                 "in3" or "in^3"
Cubic light-year                         "ly3" or "ly^3"
Cubic meter                               "m3" or "m^3"
Cubic Mile                                 "mi3" or "mi^3"
Cubic yard                                 "yd3" or "yd^3"
Cubic nautical mile                    "Nmi3" or "Nmi^3"
Cubic Pica                                 "Picapt3", "Picapt^3", "Pica3" or "Pica^3"
Gross Registered Ton                "GRT" ("regton")
Measurement ton (freight ton)  "MTON"

Area                               From_unit or to_unit
International acre           "uk_acre"
U.S. survey/statute acre  "us_acre"
Square angstrom            "ang2" or “ang^2"
Are                                 "ar"
Square feet                     "ft2" or "ft^2"
Hectare                           "ha"
Square inches                 "in2" or "in^2"
Square light-year            "ly2" or "ly^2"
Square meters                 "m2" or "m^2"
Morgen                           "Morgen"
Square miles                   "mi2" or "mi^2"
Square nautical miles     "Nmi2" or "Nmi^2"
Square Pica                    "Picapt2", "Pica2", "Pica^2" or "Picapt^2"
Square yards                  "yd2" or "yd^2" 

Information From_unit or to_unit
Bit                 "bit"
Byte               "byte"

Speed                    From_unit or to_unit
Admiralty knot      "admkn"
Knot                      "kn"
Meters per hour     "m/h" or "m/hr"
Meters per second "m/s" or "m/sec"
Miles per hour       "mph"
The following abbreviated unit prefixes can be prepended to any metric from_unit or to_unit.

Prefix | Multiplier | Abbreviation
yotta    1E+24        "Y"
zetta     1E+21        "Z"
exa       1E+18        "E"
peta      1E+15        "P"
tera       1E+12        "T"
giga      1E+09        "G"
mega    1E+06        "M"
kilo       1E+03        "k"
hecto    1E+02        "h"
dekao   1E+01        "da" or "e"
deci      1E-01         "d"
centi     1E-02         "c"
milli      1E-03         "m"
micro    1E-06         "u"
nano     1E-09         "n"
pico      1E-12         "p"
femto   1E-15         "f"
atto      1E-18         "a"
zepto    1E-21         "z"
yocto    1E-24         "y"

Binary Prefix Prefix Value                                                 Abbreviation Derived from
yobi                  2^80 = 1 208 925 819 614 629 174 706 176 "Yi"                 yotta
zebi                  2^70 = 1 180 591 620 717 411 303 424        "Zi"                 zetta
exbi                  2^60 = 1 152 921 504 606 846 976               "Ei"                 exa
pebi                  2^50 = 1 125 899 906 842 624                      "Pi"                  peta
tebi                   2^40 = 1 099 511 627 776                             "Ti"                  tera
gibi                   2^30 = 1 073 741 824                                    "Gi"                 giga
mebi                 2^20 = 1 048 576                                           "Mi"                mega
kibi                   2^10 = 1024                                                   "ki"                  kilo

Remarks
If the input data types are incorrect, CONVERT returns the #VALUE! error value. If the unit does not exist, CONVERT returns the #N/A error value.
 
If the unit does not support a binary prefix, CONVERT returns the #N/A error value. If the units are in different groups, CONVERT returns the #N/A error value. Unit names and prefixes are case-sensitive.

Q:
How to convert a value “8” from bit to byte?
= Type the function as follows in the cell that you would like to get the result in:
=CONVERT(1024, “bit”, “byte”)

For more understanding, look at the screenshot please:
Picture
0 Comments



Leave a Reply.

    Archives

    January 2018

    RSS Feed

​WELCOME TO WWW.COMTEACHERS.COM and We Would Love To Have You Visit Next Time Too! FOR MOBILE USERS, TO READ THE NOTES PLEASE CLICK MENU ICON, IT SHOULD BE EITHER ON TOP LEFT OR RIGHT CORNER OF YOUR SCREEN AND THEN CLICK MENU BY MENU TO CONTINUE READINGS...
  • HOME
  • INTRO & WINDOWS
    • INTRODUCTION >
      • FUNDAMENTAL OF IT
      • TYPE OF COMPUTER DEVICES
      • COMPUTER GENERATION
      • SYSTEM COMPUTER
      • TYPE OF COMPUTERS
      • NUMBERING SYSTEM
      • TYPE OF MOUSE
      • KEYBOARD
      • DATA PROCESSING
      • OPERATING SYSTEM
      • HISTORY OF COMPUTER
    • MS WINDOWS >
      • ABOUT MS WINDOWS
      • WINDOWS DESKTOP
      • Win Control Activation
  • MS OFFICE
    • ABOUT MS-OFFICE
    • MS WORD >
      • INTRO TO MS-WORD
      • FILE >
        • INFO, NEW, OPEN
        • SAVE AND SAVE AS, PRINT
        • SHARE, EXPORT, CLOSE
      • HOME >
        • CUT, COPY, PASTE, FORMAT PAI
        • FONT
        • STYLES
        • FIND, GO TO, REPLACE
      • INSERT >
        • PAGES -COVER, BLANK, BREAK
        • TABLES
        • ILLUSTRATIONS >
          • PICTURES, ONLINE PICTURE
          • SHAPES, ICONS, 3D MODELS
          • SmartArt
          • CHART, SCREENSHOT
        • LINK, BOOKMARK, CROSS-REF
        • COMMENT, HEADER/FOOTER
        • TEXTS >
          • TEXT BOX, WORDART, DROP CAP, OBJECT
        • SYMBOL
      • DRAW >
        • PENS
      • DESIGN >
        • DOC STYLES, WATERMARK
        • PHARAGRAPH
        • PAGE COLOR, BORDERS
      • LAYOUT >
        • PAGE SETUP, SPACING
        • ARRANGE OBJECTS
      • REFERENCES >
        • TABLE OF CONTENTS
      • MAILINGS >
        • ENVELOPES
      • REVIEW >
        • DOC REVIEWS
      • VIEW >
        • WEB LAYOUT, NEW WIN, SPLIT
        • SWITCH WINDOWS, MACROS
    • MS EXCEL >
      • INTRO TO MS-EXCEL
      • FILE >
        • INFO, NEW, OPEN
        • SAVE/SAVE AS, PRINT
        • SHARE, EXPORT
      • HOME >
        • ALIGNMENT >
          • CELL ALIGN, ORIENTATION
          • INDENTS, MERGE & CENTER
        • NUMBER, COND FORMAT
        • TABLE, INSERT, DELETE
        • FORMAT >
          • ROW HEIGHT, COLUMN WIDTH
          • HIDE, RENAME, MOVE OR COPY
        • PROTECT SHEET, FILL
        • SORT & FILTER, AUTOSUM
      • FORMULAS >
        • INTRO TO FORMULAS
        • MATH & TRIM >
          • ABS( ), COMBIN( )
          • SUM FUNCTIONS( )
          • COS( ), SIN( )
          • BASE( )
        • STATISTICAL >
          • AVERAGE FUNCTIONS( )
          • MAX FUNCTIONS( )
          • MIN FUNCTIONS( )
          • COUNT FUNCTIONS( )
          • MODE FUNCTIONS( )
        • ENGINEERING >
          • BIN2DEC
          • CONVERT
        • TEXT FUNCTIONS >
          • LEFT( ) RIGHT( ) MID( )
          • FIND( ) LEN( ) PROPER( )
          • TRIM( ) EXACT( ) FIXED( )
          • REPLACE, UNICHAR, UNICODE
          • CODE( ) CHAR( ) REPT( )
        • DATE & TIME FUNCTIONS >
          • TODAY( ) YEAR( ) DAYS( )
        • LOGICAL >
          • IF( ), IFERROR( )
          • IFS( ), SWITCH( )
          • AND( ), OR( )
          • IFNA( ), XOR( )
      • INSERT >
        • CHARTS, SPARKLINES
      • PAGE LAYOUT >
        • PRINT TITLES, SHEET OPTION
      • DATA >
        • GET DATA, DATA VALIDATION
        • CONSOLIDATE
      • VIEW >
        • WORKBOOK VIEWS
      • Excel Functions Exercises >
        • Exercises 1 and 2
        • Exercises 3 and 4
    • MS POWER POINT >
      • INTRO TO MS-POWERPOINT
      • FILE >
        • INFO, NEW, OPEN
        • SAVE AND SAVE AS, PRINT
        • SHARE, EXPORT, CLOSE
      • HOME >
        • NEW SLIDE, STYLES, FILL
      • INSERT >
        • PHOTO ALBUM, VIDEO, AUDIO
        • SCREEN REC, SHOT, SLIDE NUM
      • DESIGN >
        • THEMES, SLIDESIZE, FORMAT
      • TRANSITION >
        • TRANSITION, SOUND
    • MS ACCESS >
      • INTRO TO MS-ACCESS
      • FILE >
        • HOME, NEW, OPEN
    • OFFICE QUESTION & ANSWER
  • VISUAL STUDIO
    • VISUAL BASIC .NET >
      • INTRODUCTION
      • .NET FRAMEWORK
      • OPERATORS IN VB.NET
      • DATAYPES IN VB.NET
      • VB.NET KEYWORDS
      • VARIABLE AND CONST
      • INTRO TO VB.NET PLATFORM
      • INTRO TO PROGRAMMING
      • OBJECTS USAGE IN WIN-FORM
    • Python >
      • Introduction
    • C++
  • GOOGLE TIPS
    • GMAIL ACCOUNT >
      • Email Forwarding
      • Setting up Authenticator App
      • SIGNATURE SET UP
    • GOOGLE WORKSPACE
  • INVENTS
    • NEW INVENTS
  • ABOUT ME