ICT Tutorials
  • HOME
  • 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
  • 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
  • PROGRAMMING
    • Python >
      • Introduction
    • C++
    • VISUAL BASIC
  • WEB & NETWORK
    • NETWORKING
    • WEBSITE DESIGNING >
      • DHTML
      • CSS
      • PHP
      • JAVA SCRIPT
  • 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

Powered by Create your own unique website with customizable templates.
  • HOME
  • 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
  • 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
  • PROGRAMMING
    • Python >
      • Introduction
    • C++
    • VISUAL BASIC
  • WEB & NETWORK
    • NETWORKING
    • WEBSITE DESIGNING >
      • DHTML
      • CSS
      • PHP
      • JAVA SCRIPT
  • INVENTS
    • NEW INVENTS
  • ABOUT ME