ENGINEERING Articles: Excel and Google Sheets

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 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...

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...

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....

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...

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...

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...

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...