Manuals/calci/OCT2BIN

OCT2BIN(number, places)

• Where 'number' is the octal integer to be converted and

• 'places' is the number of characters to display the output.

OCT2BIN() function converts an octal number to its binary equivalent.

Description

OCT2BIN(number, places)

• The 'number' should be in the range '7777777000' to '777'. If it exceeds the limit, Calci gives a #NUM! error.

• Calci returns an #ERROR, when the 'number' is nonnumeric.

• 'places' argument is used to return the output with leading zeros. If 'places' argument is not used, 'Calci' uses the minimum number of characters required to display the binary output.

• If 'places' is negative, Calci ignores the places and displays a 10 bit binary output. Most significant bit is the sign bit and remaining are magnitude bits.

• If 'places' is not an integer, Calci truncates the value and uses the integer part as input.

• A number preceding with '0' (e.g. 0377) should be written in text format ("0377") to avoid confusion with octal numbers.

For example,

DEC2BIN(10, 4) returns 1010

DEC2BIN(100) returns 0001100100

DEC2BIN(30,5.5) returns 011110

Syntax

---

Examples

---

'''''''  ''''

---

Description

---

 

This function converts an octal number to binary.

---

OCT2BIN

---

 

OCT2BIN(N,p)

where  N   is the octal number and p is the number of characters to use.

---

	Column1	Column2	Column3	Column4
Row1	101
Row2
Row3
Row4
Row5
Row6

File:Calci1.gif

---

Let's see an example

I.e. =OCT2BIN(5,3) is 101

---