All resources related to ENGINEERING for Excel and Google Sheets.

Excel BIN2DEC Function

Excel BIN2DEC Function will convert from a binary number and return to its decimal equivalent. This article will show you exactly how to use BIN2DEC Function Formula The syntax for Excel BIN2DEC function is: =BIN2DEC (number) Where “number” is the binary number to be converted to decimal Explanation The BIN2DEC...

Excel BITRSHIFT Function

Excel BITRSHIFT Function changes a number into equivalent binary, shifts right by a specified number of bits, then converts back to a number. Generic Formula =BITRSHIFT(number,shift_amount) Number Required. Must be a positive integer or equal to 0 Shift_amount Required. Must be an integer. Example Below are some examples of this...

How to Use the BITAND Function in Excel

The BITAND function applies the AND operation on two decimal number. In the AND operation, the bitwise and is applied. This step by step tutorial will assist all levels of Excel users in understanding the binary conversion and the BITAND function. Figure 1. The result of the function Conversion of...

How to apply the Excel BITOR function

We can use the Excel BITOR function to get the Bitwise “OR”, which is the binary equivalent of two numbers. With the BITOR function, a binary representation of the numbers is used in operation and a decimal value becomes the returned result. The steps below will walk through the process....

Excel BIN2HEX Function

Binary numbers are commonly applied in computer technology. However, more people prefer to use hexadecimals in mathematics, computations and computer programming because it is easier to understand. The table below shows the conversion of the decimal numbers 1 to 15 to binary and hexadecimals. Figure 1. Decimal numbers...

Excel CONVERT Function

We can use the excel CONVERT FUNCTION to convert a number from one measurement to another. Some measurements are Meters, Kilometers, Fahrenheit, Celsius, Inches, Gram, etc. The steps below will walk through the process. Figure 1: How to Use the Convert Function Syntax =CONVERT(number, from_unit, to_unit) Where “Number” is the...

How to use the Excel DEC2HEX Function

We have some very effective functions when it comes to working with numbers in Excel. DEC2HEX is one such function. It takes a decimal number and converts it to its hexadecimal counterpart. In this tutorial, we will learn how to use the DEX2HEC function in Excel. Figure 1. Example of...

Excel HEX2DEC Function

Microsoft Excel offers some very effective functions to work with numbers. One such function is the HEX2DEC function. The HEX2DEC function converts a hexadecimal number to its decimal counterpart. In this tutorial, we will learn how to use the HEX2DEC function in Excel. Figure 1. Example of How to Use...