Excel Trivia | Everything about Excel Function and Formulas: Engineering Functions

Showing posts with label Engineering Functions. Show all posts

OCT2DEC Function | Microsoft Excel

Urvil Darji August 15, 2018 0

You can convert octal numbers into decimal numbers
Octal numbers contain 0 to 7 values

OCT2DEC Function has a limit of 777 octal numbers
If you write more than 777 characters it will return #NUM error

Syntax of OCT2DEC Function

=OCT2DEC(number)

Argument of OCT2DEC Function

Number: it is the number you want to convert into octal

Behavior of OCT2DEC Function

Here we have taken an example of the octal number and convert it into decimal numbers.
We have written a formula
=OCT2DEC(D4) which will convert the binary number into octal numbers
On the right side, if you write 777 it will return "511"
If you write 778 it will return #NUM error because it is the limit of the Function

Usage of OCT2DEC Function

To convert an Octal number into a Decimal number

Returns of OCT2DEC Function

Decimal number

Tags # Engineering Functions Continue Reading

OCT2BIN Function | Microsoft Excel

Urvil Darji August 15, 2018 0

You can convert octal numbers into binary numbers
The binary numbers contain only 0 and 1 values
Octal numbers contain 0 to 7 values
OCT2BIN Function has a limit of 777 octal numbers
If you write more than 777 characters it will return #NUM error

Syntax of OCT2BIN Function

=OCT2BIN(number,[places])

Argument of OCT2BIN Function

Number: it is the number you want to convert into octal
Places:[Optional] how many characters you want to show in your result. It will place "0" before the result.

Behavior of OCT2BIN Function

Here we have taken an example of the octal number and convert it into binary numbers.
We have written a formula
=OCT2BIN(D4,10) which will convert the binary number into octal and show result till 10 characters. No character place is fill by 0
On the right side, if you write 777 it will return 9 times "1"
If you write 778 it will return #NUM error because in banary number it becomees 10 charecter
Usage of OCT2BIN Function

To convert an Octal number into a Binary number

Returns of OCT2BIN Function

Binary number

Tags # Engineering Functions Continue Reading

OCT2HEX Function | Microsoft Excel

Urvil Darji August 15, 2018 0

You can convert octal numbers into hexadecimal numbers
The hexadecimal numbers contain only 0 and F values
Octal numbers contain 0 to 7 values
OCT2HEX Function has a limit of 777 octal numbers
If you write more than 777 characters it will return #NUM error

Syntax of OCT2HEX Function

=OCT2HEX(number,[places])

Argument of OCT2HEX Function

Number: it is the number you want to convert into hexadecimal
Places:[Optional] how many characters you want to show in your result. It will place "0" before the result.

Behavior of OCT2HEX Function

Here we have taken an example of the octal number and convert it into hexadecimal numbers.
We have written a formula
=OCT2HEX(D4,5) which will convert the octal number into hexadecimal and show result till 5 characters. No character place is filled by 0
On the right side, if you write 777 it will return "1FF:
If you write 778 it will return #NUM error

Usage of OCT2HEX Function

To convert an Octal number into a Hexadecimal number

Returns of OCT2HEX Function

Hexadecimal number

Tags # Engineering Functions Continue Reading

BIN2DEC Function

Urvil Darji August 15, 2018 0

You can convert binary number to a decimal number.
The binary number contains only 0 and 1 values.
Decimal pattern is 8 4 2 1.

It has a limit of 10 characters
If you write 10 times 1 it will return -1

Syntax

=BIN2DEC(number)

Arguments

Number: The binary number(reference) which you want to convert in to decimal.

Behavior

Here we have taken an example of binary numbers from"000" to "111" which gives result in decimal numbers

A limit of this function is 10 character. If you write 10 times "1" function will return "-1" as shown in above example

If you write more than 10 characters to function it will return #NUM error.

Usage

BIN2DEC Function is used to convert a binary number into a decimal number

Returns

If you give the binary number the function will return the decimal number

Tags # Engineering Functions Continue Reading

DEC2BIN Function

Urvil Darji August 15, 2018 0

You can convert Decimal numbers into binary numbers
The binary numbers contain only 0 and 1 values

DEC2BIN Function has a limit of 511 Decimal numbers
If you write more than 511 characters it will return #NUM error

Syntax

=DEC2BIN(number,[places])

Argument

Number: it is the number you want to convert into binary
Places:[Optional] how many characters you want to show in your result. It will place "0" before the result.

Behavior

Here we have taken an example of the decimal number and convert it into binary numbers.
We have written a formula

=DEC2BIN(D4,9) which will convert the decimal number into binary and show result till 9 characters. No character place is fill by 0

On the right side, if you write 511 it will return 9 times "1"
If you write 512 it will return #NUM error

Usage

To convert a Decimal number into a Binary number

Returns

Binary number

Tags # Engineering Functions Continue Reading

DEC2OCT Function

Urvil Darji August 15, 2018 0

You can convert decimal numbers into octal numbers
Octal numbers contain 0 to 7 values

DEC2OCT Function has a limit of eight times "9"
If you write nine times "9" characters it will return #NUM error

Syntax

=DEC2OCT(number,[place])

Argument

Number: it is the number you want to convert into octal
Places:[Optional] how many characters you want to show in your result. It will place "0" before the result.

Behavior

Here we have taken an example of the decimal number and convert it into octal numbers.
We have written a formula

=DEC2OCT(D4,4) which will convert the decimal number into octal numbers

On the right side, if you write eight times "9" it will return "575360377"
If you write nine times "9" it will return #NUM error because it is the limit of the Function

Usage

To convert an Decimal number into a Octal number

Returns

Octal number

Tags # Engineering Functions Continue Reading

BIN2HEX Function

Urvil Darji August 15, 2018 0

You can convert binary numbers into hexadecimal numbers
The binary numbers contain only 0 and 1 values
Oct numbers contain 0 to 15 values

BIN2HEX Function has a limit of 10 characters

If you write more than 10 characters it will return #NUM error

Syntax

=BIN2HEX(number,[places])

Argument

Number: it is the number you want to convert into octal
Places:[Optional] how many characters you want to show in your result. It will place "0" before the result.

Behavior

Here we have taken an example of the binary number and convert it into HexaDecimal numbers. We have written a formula

=BIN2hex(D4,4) which will convert the binary number into hexadecimal and show result till 4 characters. No character place is filled by 0

On the right side, if you write 10 times "1" it will return 10 times "F"
If you write more than 10 characters it will return #NUM error

Usage

To convert a Binary number into a hexadecimal number

Returns

HexaDecimal number

Tags # Engineering Functions Continue Reading

HEX2BIN Function

Urvil Darji August 15, 2018 0

You can convert hexadecimal numbers into binary numbers
The binary numbers contain only 0 and 1 values
Hexadecimal numbers contain 0 to 15 values

HEX2BIN Function has a limit of 10 characters(1FF in HEX) in binary numbers

If you write more than 10 characters(More then 1FF) it will return #NUM error

Syntax

=HEX2BIN(number,[places])

Argument

Number: it is the number you want to convert into binary
Places:[Optional] how many characters you want to show in your result. It will place "0" before the result.

Behavior

Here we have taken an example of the Hexadecimal number and convert it into Binary numbers. We have written a formula

=HEX2BINJ(D4,10) which will convert the binary number into hexadecimal and show result till 10 characters. No character place is filled by 0

On the right side, if you write 1FF it will return "111111111"
If you write more than 1FF(2FF and more) characters it will return #NUM error

Usage

To convert a HExadecimal number into a Binary number

Returns

Binary number

Tags # Engineering Functions Continue Reading

HEX2DEC Function

Urvil Darji August 15, 2018 0

You can convert Hexadecimal numbers into decimal numbers
The hexadecimal numbers contain only 0 and F values

HEX2DEC Function has a limit of nine times "f" decimal numbers
If you write more than ten times "F" characters it will return"-1"
If you write more than ten times"F" it will return #NUM error

Syntax

=DEC2HEX(number)

Argument

Number: it is the number you want to convert into hexadecimal

Behavior

Here we have taken an example of the hexadecimal number and convert it into decimal numbers.
We have written a formula

=HEX2DEC(D4) which will convert the hexadecimal number into decimal

On the right side, if you write nine times "F" it will return "68719476735"
if you write ten times "F" it will return "-1"
If you write more then ten times "F" it will return #NUM error

Usage

To convert a Hexadecimal number into a Decimal number

Returns

Decimal number

Tags # Engineering Functions Continue Reading

HEX2OCT Function

Urvil Darji August 15, 2018 0

You can convert hexadecimal numbers into octal numbers
The hexadecimal numbers contain only 0 and F values
Octal numbers contain 0 to 7 values

OCT2HEX Function has a limit of ten times of "F" hexadecimal numbers
If you write more than ten times "F" characters it will return #NUM error

Syntax

=HEX2OCT(number)

Argument

Number: it is the number you want to convert into octal numbers

Behavior

Here we have taken an example of the hexadecimal number and convert it into octal numbers.
We have written a formula

=HEX2OCT(D4) which will convert the hexadecimal number into octal

On the right side, if you write ten times "F" it will return "7777777777"
If you write more than ten times "F" it will return #NUM error

Usage

To convert a Hexadecimal number into a OCtal number

Returns

Octal number

Tags # Engineering Functions Continue Reading

DEC2HEX Function

Urvil Darji August 15, 2018 0

You can convert decimal numbers into hexadecimal numbers
The hexadecimal numbers contain only 0 and F values

DEC2HEX Function has a limit of eleven times "9" decimal numbers
If you write more than eleven times "9" characters it will return #NUM error

Syntax

=DEC2HEX(number,[places])

Argument

Number: it is the number you want to convert into hexadecimal
Places:[Optional] how many characters you want to show in your result. It will place "0" before the result.

Behavior

Here we have taken an example of the decimal number and convert it into hexadecimal numbers.
We have written a formula

=DEC2HEX(D4,4) which will convert the decimal number into hexadecimal and show result till 4 characters. No character place is filled by 0

On the right side, if you write eleven times "9" it will return "174876E7FF"
If you write more then eleven times "9" it will return #NUM error

Usage

To convert a Decimal number into a Hexadecimal number

Returns

Hexadecimal number

Tags # Engineering Functions Continue Reading

How To Use CONVERT Function | Microsoft Excel

Urvil Darji August 15, 2018 0

CONVERT Function will convert measurements between two units. If you want to convert the area from Hectare to Acre, weights from Pounds to Kilograms, temperature from Ferenhite to Celsius etc.

Syntax of CONVERT Function

=CONVERT(number,from_unit,to_unit)

Arguments of CONVERT Function

number: It is the value which you want to convert
from_unit: The value unit which you have
to_unit: The resultant unit value

Behavior of CONVERT Function

Here we have taken an example of the measurements Speed, Weight, and Area.

you can see the from a unit and to units and its conversion in resultant unit

Usage of CONVERT Function

To convert one measurement unit into another measurement unit

Return Value from CONVERT Function

The converted measurement value of given unit

Useful Parameteres with units for CONVERT Function

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"

Tags # Engineering Functions Continue Reading

OCT2DEC Function | Microsoft Excel

Syntax of OCT2DEC Function

Argument of OCT2DEC Function

Behavior of OCT2DEC Function

Usage of OCT2DEC Function

Returns of OCT2DEC Function

OCT2BIN Function | Microsoft Excel

Syntax of OCT2BIN Function

Argument of OCT2BIN Function

Behavior of OCT2BIN Function

Returns of OCT2BIN Function

OCT2HEX Function | Microsoft Excel

Syntax of OCT2HEX Function

Argument of OCT2HEX Function

Behavior of OCT2HEX Function

Usage of OCT2HEX Function

Returns of OCT2HEX Function

BIN2DEC Function

DEC2BIN Function

DEC2OCT Function

BIN2HEX Function

HEX2BIN Function

HEX2DEC Function

HEX2OCT Function

DEC2HEX Function

How To Use CONVERT Function | Microsoft Excel

Syntax of CONVERT Function

Arguments of CONVERT Function

Behavior of CONVERT Function

Usage of CONVERT Function

Return Value from CONVERT Function

Useful Parameteres with units for CONVERT Function

Popular

Recent

Followers

Tags