Showing posts with label Engineering Functions. Show all posts
Showing posts with label Engineering Functions. Show all posts

OCT2DEC Function | Microsoft Excel

August 15, 2018 0
how to use oct2dec functionh in excel
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
No comments:
Labels:

OCT2BIN Function | Microsoft Excel

August 15, 2018 0
how to use oct2bin function in excel

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
No comments:
Labels:

OCT2HEX Function | Microsoft Excel

August 15, 2018 0
how to use oct2hex function in excel

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
No comments:
Labels:

BIN2DEC Function

August 15, 2018 0
how to use bin2dec function in excel
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
No comments:
Labels:

DEC2BIN Function

August 15, 2018 0
how to use dec2bin function in excel
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
No comments:
Labels: