Difference between revisions of "Manuals/calci/BIN2DEC"

From ZCubes Wiki
Jump to navigation Jump to search
Line 7: Line 7:
  
 
BIN2DEC(number)
 
BIN2DEC(number)
 +
 +
For example, BIN2DEC(101) ''returns 5'' as a result.
 +
 +
            BIN2DEC(11110) ''returns 30'' as a result.
  
 
*BIN2DEC() converts a binary number to decimal number.
 
*BIN2DEC() converts a binary number to decimal number.
  
*Binaray number is represented using digits 1 or 0 only.
+
*Binaray number is represented using digits 1 or 0 only. The number can also be entered in text format (e.g "101").
  
 
*The conversion can be obtained for a binary number upto 10 bits. The most significant bit represents the 'sign' of the number (0=positive, 1=negative). Negative numbers are represented using 2's complement notation.
 
*The conversion can be obtained for a binary number upto 10 bits. The most significant bit represents the 'sign' of the number (0=positive, 1=negative). Negative numbers are represented using 2's complement notation.

Revision as of 15:58, 12 November 2013

BIN2DEC(number)

  • Where 'number' is the binary number to be converted to decimal number.


Description

BIN2DEC(number)

For example, BIN2DEC(101) returns 5 as a result.

            BIN2DEC(11110) returns 30 as a result. 
  • BIN2DEC() converts a binary number to decimal number.
  • Binaray number is represented using digits 1 or 0 only. The number can also be entered in text format (e.g "101").
  • The conversion can be obtained for a binary number upto 10 bits. The most significant bit represents the 'sign' of the number (0=positive, 1=negative). Negative numbers are represented using 2's complement notation.
  • Positive numbers can be from 0 (000000000) to 511 (111111111) or negative numbers -1 (1000000001) to -512 (1111111111).
  • A binary number (e.g '101') can be converted to decimal number (base 2) as -
(1*2^2)+(0*2^1)+(1*2^0)=4+0+1= 5
  • If the number is not a valid number, 'Calci' returns an #ERROR message.

 

BIN2DEC returns the error value., when number contains more than 10 characters (10 bits).


BIN2DEC


 

[javascript:ToggleDiv('divExpCollAsst_4') BIN2DEC][javascript:ToggleDiv('divExpCollAsst_4') (][javascript:ToggleDiv('divExpCollAsst_4') num][javascript:ToggleDiv('divExpCollAsst_4') )]

[javascript:ToggleDiv('divExpCollAsst_4') =BIN2DEC(1100100) is 100]


Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 100
Row2
Row3
Row4
Row5
Row6