Engineering

Excel Engineering functions explained with syntax, examples and common mistakes.

OCT2BIN Function in Excel: Octal to Binary

EngineeringOCT2BIN=OCT2BIN(A2)→ 111

27 Apr 2020 · Engineering · 1 min read

OCT2BIN Function in Excel: Octal to Binary

OCT2BIN converts a octal number to binary. Used for device codes, permission bits, memory addresses and number-system lessons.

Read article →

HEX2DEC Function in Excel: Hexadecimal to Decimal

EngineeringHEX2DEC=HEX2DEC(A2)→ 255

24 Apr 2020 · Engineering · 1 min read

HEX2DEC Function in Excel: Hexadecimal to Decimal

EngineeringLevel: IntermediateAvailable in: Excel 2007+HEX2DEC reads hex text — colour codes, error codes from logs — as a.

Read article →

DEC2HEX Function in Excel: Decimal to Hexadecimal

EngineeringDEC2HEX=DEC2HEX(A2)→ FF

13 Aug 2019 · Engineering · 1 min read

DEC2HEX Function in Excel: Decimal to Hexadecimal

DEC2HEX converts numbers to hex — the notation behind web colours and memory addresses.

Read article →

BIN2DEC Function in Excel: Binary to Decimal

EngineeringBIN2DEC=BIN2DEC(A2)→ 10

6 Aug 2019 · Engineering · 1 min read

BIN2DEC Function in Excel: Binary to Decimal

EngineeringLevel: IntermediateAvailable in: Excel 2007+BIN2DEC reads binary text (up to 10 digits) and returns the.

Read article →

DEC2BIN Function in Excel: Decimal to Binary

EngineeringDEC2BIN=DEC2BIN(A2,8)→ 00000101

30 Jul 2019 · Engineering · 1 min read

DEC2BIN Function in Excel: Decimal to Binary

DEC2BIN converts a number to binary text. Good for teaching, flags and subnet masks, but it only handles −512 to 511.

Read article →

CONVERT Function in Excel: Convert Units

EngineeringCONVERT=ROUND(CONVERT(A2,B2,C2),2)→ 110.23

23 Jul 2019 · Engineering · 1 min read

CONVERT Function in Excel: Convert Units

CONVERT changes units: km to miles, °C to °F, kg to pounds, hours to minutes. Unit codes are case-sensitive.

Read article →