About BIN2OCT() function
The BIN2HEX() function is an Engineering function that converts a binary number into octal decimal number. It keeps a single argument that is number.
Where to apply :
This function is used by engineers where machines need to convert the binary number into octal decimal number. It is also used in education.
number- A number in binary form. it means in 1 and 0 form.
1. If the binary number is 1011.
=BIN2OCT(1011) // Returns (B)
It returns B for the binary number 1011.
Excel based example:
The BIN2OCT() function is well explained in above image.
Hope, it would have added in your Excel function knowledge.
Best Excel training institute in Noida provides Basic Excel, Advance Excel and VBA offline and online classes.
If you want to learn Excel & VBA courses to be Excel expert, connect us on:
9599408486 / 8929231250